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
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.
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.