Subject | Simulating Boolean field |
---|---|
Author | Bc. Jiri Cincura |
Post date | 2005-09-02T09:06:51Z |
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
http://www.ID3renamer.com/
http://www.x2develop.com/
ICQ: 314711544 | Yahoo!: x2develop
http://photo.cincura.net/
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
http://www.ID3renamer.com/
http://www.x2develop.com/
ICQ: 314711544 | Yahoo!: x2develop
http://photo.cincura.net/