Subject RE: [firebird-support] Simulating Boolean field
Author Bill Meaney
>Ivan Prenosil wrote (on Friday, September 02, 2005 1:55 PM):
>> Another alternative is SMALLINT, which has the advantage that
>> - it is language independent (no variants like T/F, Y/N, A/N, etc)
>> - it is always sorted correctly (0<1)
>> - if true boolean will be implemented, it is more likely to be stored as
>> number (I think)
>Yeah, the SMALLINT idea is good. ;)

Also, SMALLINT is not case sensitive.

Bill Meaney