2016-04-14 19:49 GMT+02:00 Jay Kreibich <jay at kreibi.ch>: > > On Apr 14, 2016, at 12:42 PM, Cecil Westerhof <cldwesterhof at gmail.com> > wrote: > > > When working with booleans at the moment I use: > > isActive INTEGER NOT NULL CHECK(isActive in (0, 1)) > > > > Is this a good way, or would be using a CHAR with a check op 'T', or 'F' > be > > better? > > > > Integer 1 and 0 will be the most compact representation in the file format. >
?OK, I will stick with it then. -- Cecil Westerhof