Subject RE: [firebird-support] Simulating Boolean field
Author Alan McDonald
> Hi,
>
> today morning I was thinking about the Boolean simulation in FB 1.5 . I've
> found two solutions.
> 1: char(1) with 'T' and 'F' and some validation (check, trigger)
> 2: char(1) with X (as Yes/True) and NULL (No/False)
>
> What's better (performance, management, ...)?
> How you're working with Boolean?
>
> --
> Bc. Jiri Cincura

not much difference performance wise. (use check constraints rather than
just triggers)
It mostly depends on the connection layer you have and what it specifically
likes if anything.

Alan