Thanks. This question started on the firebird-support list.
I noticed that Jaybird was storing Y/N, so I changed my BOOLEAN domain
definition to check for Y or N.
I agree, I'd prefer the SQL-92 BIT to be supported.

-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Friday, October 29, 2004 4:56 PM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] FW: [firebird-support] Boolean Fields

> Can the handling of Boolean types be configured?

As far as I remember - no. JDBC standard does not define any mapping
between boolean and SMALLINT/CHAR/etc, only between boolean and BIT data
type. JayBird supports 'Y'/'N', "true"/"false", 'T'/'F' and 1/0
mappings.

So far there were no request to make this configurable, therefore the
mappings are hardcoded. It is not hard to add such feature, but it
better
be solved on server by introducing the BIT data type.

Roman




Yahoo! Groups Links