Subject RE: [firebird-support] Boolean Fields
Author Helen Borrie
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 would
be extremely surprising if the JDBC standard for Booleans were locked into
a single, Engllish-language, character convention. It is much more likely
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 type,
domain, or both. For example, with the domain flag included in a set
property named FieldEntryTypes, one can do this at connection level: