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