I don't know if this helps, but I created a boolean_type table...
create table boolean_type (
boolean_type_id char(1) not null primary key,
boolean_type_name varchar(5) not null
);
insert into boolean_type values ('Y', 'true');
insert into boolean_type values ('N', 'false');
and then I use it
Hi Joel,
There is a lot of interest in enabling the BOOLEAN datatype.
Unfortunately, our first attempt at this foundered on network protocol
and release-compatibility issues. At this time, we don't understand how
to enable this datatype without issuing a major release of Derby
(release 11).
We would like to migrate to Derby, but we
have encountered some difficulty in regard to support for Boolean operations.
It isn’t critical to us that Derby store Booleans,
but there are some operations in a large number of our SQL statements that appear
to be unsupported on Derby.
For in