SQLite booleans?

N1c0_ds

Active Member
Licensed User
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
 
Last edited:

RB Smissaert

Well-Known Member
Licensed User
Longtime User
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
 
Top