--- In firebird-support@yahoogroups.com, "women_lover_best"
<talbronstien@g...> wrote:

> For boolean what datatype should I use? What size is char..how much
> space one char occupies?

You can use a domain to enforce a set of valid characters.

eg:

CREATE DOMAIN "BOOLCHAR" AS CHAR(1)
check( (value in ('T','F')) or value is null );

It occupies one byte. We investigated this or whether to use a
smallint etc, and found that (in Delphi anyway) it loaded correctly
into a TBooleanField, which was really nice.

Adam