Subject RE: [firebird-support] Boolean Fields
Author Rick DeBay
Rereading I find that JDBC recommends the SQL-92 BIT datatype, and if
that is not available TINYINT. The value stored in any other type is
driver dependant. I have asked on firebird-java if it can be
configured. Any further discussion will be continued there.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, October 28, 2004 8:21 PM
Subject: RE: [firebird-support] Boolean Fields

At 02:29 PM 28/10/2004 -0400, you wrote:

>I originally used the domain suggested in Helen's book, but changed the
>values stored to 'Y' and 'N' to conform to Jaybird's handling of the
>Java Boolean type.
>If there is ever a chance of a Java application accessing your DB, you
>may want to use Y/N.

I think you should double-check this on the firebird-java list. It
be extremely surprising if the JDBC standard for Booleans were locked
a single, Engllish-language, character convention. It is much more
that there is some property you can set, at either table or connection
level, to tell the driver how to recognise your Boolean convention. I'd
assume that "Y/N" is merely a default.

In IB Objects, for example, you can assign any convention that's
appropriate for your data. At statement level, one sets this property:


With this interface, one can also set it globally, according to SQL
domain, or both. For example, with the domain flag included in a set
property named FieldEntryTypes, one can do this at connection level:



Yahoo! Groups Links