On Fri, Apr 20, 2012 at 04:41:46AM +1000, John scratched on the wall: > On 19/04/2012 5:14 AM, Jay A. Kreibich wrote:
> > The type "BOOLEAN" will pick up a numeric affinity, but I can't see > > that being an issue. Most Boolean values are stored as integer 0 or > > 1 (in fact, SQLite has optimizations to store integer values 0 and > > 1 for just this case). > > That is interesting to know, I tend to use -1 as true (misspent > youth dabbling in Forth on 8 bit machines). The optimization saves a whole byte per value, but yes... integer values 0 and 1 are special. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
