Subject | RE: [firebird-support] Simulating Boolean field |
---|---|
Author | Alan McDonald |
Post date | 2005-09-02T09:31:48Z |
> Hi,not much difference performance wise. (use check constraints rather than
>
> 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
just triggers)
It mostly depends on the connection layer you have and what it specifically
likes if anything.
Alan