Hi All,
I have an app that stores it's local data in a database, The database has a
TEXT field called description that on some rows is truncated on retrieval. I
have checked the database by running it app in the emulator and grabbing the
database and checking the contents. So I know the data is there. I retrieve
it using:
public Cursor getAdditiveByRowID(long rowId) throws SQLException
{
Cursor mCursor =
db.query(true, Additives.DATABASE_TABLE, new String[] {
Additives.KEY_ROWID,
Additives.KEY_IDENTIFIER,
Additives.KEY_NAME,
Additives.KEY_TYPE,
Additives.KEY_DESCRIPTION,
Additives.KEY_ACKNOWLEDGEMENT,
Additives.KEY_WARNING
},
Additives.KEY_ROWID + "=" + rowId,
null,
null,
null,
null,
null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
When I use it the code looks like this:
if (cursor.moveToPosition(position))
{
Log.i(TAG,"contents from cursor =
"+cursor.getString(Additives.DESCRIPTION_COLUMN));
......
record.setDescription(cursor.getString(Additives.DESCRIPTION_COLUMN));
......
}
I checked the output and it appears to be truncating the output at various
stages (one it is 1980 chars before truncating and another it is 257 chars)
with some rows only. I checked for bad chars but as I thought it was fine (the
same database is used in my iPhone app with no problems) So it must be
something I am doing. But I can not see where as it is wrong as soon as it
comes from the database. Any assistance or advice to debug this would be more
than helpful.
Regards
Damien
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
