---- Dennis Cote <[EMAIL PROTECTED]> wrote: > John Stanton wrote: > > It does not have fixed length columns except for the ones which hold > > integer and real numbers and boolean values. > > > Actually, integers are stored in a variable length format as well. It > takes less space to store smaller integer values than it does to store > large values. This allows sqlite to handle full 64 bit integers, but > does not waste space storing unused leading zero bits for most fields > that typically use a much smaller range of integer values. > > It also has a new file format (no longer the default) that stores > booleans more efficiently. Use pragma legacy_file_format=off when > initializing the database to select this format. I believe booleans > values are fixed size in both formats. > > Dennis Cote > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- >
I am not aware of a BOOLEAN type. The types defined in the website are: NULL, INTEGER, REAL, TEXT and BLOB. Is BOOLEAN a hidden type? Ray ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------