SQLite booleans?

[N1c0_ds]

I was wondering if the BOOLEAN SQLite data type worked with Basic4PPC. I've heard about trouble with it, but it would save a lot of room if I could use it. Can anyone testify?

PS: I use SQLite Expert, as recommended by a fellow member

 

[RB Smissaert]

BOOLEAN SQLite data type?

From the SQLite website (SQLite Frequently Asked Questions
SQLite uses dynamic typing.
Content can be stored as INTEGER, REAL, TEXT, BLOB, or as NULL.
So, you are best of to store as integer, so 0 or 1. Requires just one Byte.

RBS

 

[N1c0_ds]

BOOLEAN SQLite data type?

From the SQLite website (SQLite Frequently Asked Questions
SQLite uses dynamic typing.
Content can be stored as INTEGER, REAL, TEXT, BLOB, or as NULL.
So, you are best of to store as integer, so 0 or 1. Requires just one Byte.

RBS

Cool, thanks!

UPDATE: Apparently that's exactly how Booleans work: 1 or 0!