I encountered a problem where calling Cursor.getType() for a column returns a type value of 5. The documented FIELD_TYPE values in Cursor class only contain values 0 to 4. The actual SQL datatype for the column is TEXT. Weird thing is that the same table contains a couple of other TEXT fields that are identified as type value 3.
Inserting data to table works fine, but the problem arises when I run a SELECT query.
Any ideas why this is happening? Also any directions or links any to related or similar issues is appreciated.
(I’m developing on Android, API level 18)