How to use Booleans with Delphi XE2 dbExpress and Firebird 2.5

Question

Does the new XE2 dbExpress still have problems using Boolean fields?

score 2 · Answer 1 · answered Jan 09 '13 at 08:29

2

The best way is to use a domain

CREATE DOMAIN BOOL AS
SMALLINT
DEFAULT 0
CHECK (value in (0,1) or value is null);

Regards

answered Jan 09 '13 at 08:29

cadetill

score 1 · Answer 2 · answered Oct 03 '11 at 06:02

1

AFAIK Firebird doesn't have BOOLEAN types.

answered Oct 03 '11 at 06:02

Atlas

dataol · Answer 3 · 2013-01-14T00:14:27.597

0

Create a Char(1) field. Set values "Y" or "N"

edited Jan 14 '13 at 00:14

answered Dec 30 '12 at 18:56

dataol

3 Answers3