Re: [sqlite] Booleans in SQLite

[Mark Spiegel]

Jay A. Kreibich wrote:
>   Integer values between -128 and 127 use only a single byte of storage above 
> and beyond  the header size that all values have.
>   
Not quite.  Values between 0 & 127 use 1 byte of storage.  Negative 
values use the full 9 bytes in my experience.  (I'm setting aside the 
integer 0 and integer 1 optimizations outlined in 
http://www.sqlite.org/fileformat.html#record_format with that statement.)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users