android, cursor returning boolean value?

Question

Can an Android Cursor return a boolean value? I've looked at the docs and there was no info on it?

If not - then is there an alternative way to get a boolean value from a SQLite table?

Answer 1

The android implementation of SQLite3 doesn't properly support boolean values. You will need to use integers set to 0 or 1 and write some code to convert that to a boolean e.g.

int x = cursor.getInt(...);
return x == 1;

Answer 2

Use enum type with values 'Y' and 'N' to represent the boolean value