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.