Hi,
I have created a database and and a table in sqlite which consists of datatypes(varchar, Integer and Boolean).I have inserted the data in to the table of the specified datatype. While retrieving data im quite surprised seeing that cursor.getString(columnindex) and cursor.getInt(columnindex) methods are available .. what about the boolean type i couldnt find any methods for resolving the boolean type..
Am i missing something ? any suggestions will be helpful to resolve the problem.

Hello

SQLite doesn't have a dedicated boolean type. You just store them in "C"-Style as Integer, '== 0' for false and '!= 0' for true.

Regards,
plusminus

plusminus wrote:Hello

SQLite doesn't have a dedicated boolean type. You just store them in "C"-Style as Integer, '== 0' for false and '!= 0' for true.

Regards,
plusminus

Thats the way remains what i thought was when it can accept boolean datatype then there should be someway to retrieve it also.. Then i should have to go with the c style only.

Hello Katharnavas,

yes that would be fine, just a kind of standard-wrapper within the sdk .

Regards,
plusminus