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.
Are you able to reproduce this with a unit test within the SQLCipher for Android test suite? We already have a test around the 5 documented types to be returned here.
The test application should open properly within IntelliJ, can you give that a try and build it? You can load the test application from either the included project file, or the pom.xml. Can you then create a test that reproduces the error?