db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: No BIT/BOOLEAN Data Type in Derby?
Date Wed, 15 Dec 2004 15:03:37 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Johny English wrote:

> Hi folks,
>
> I'm currently evaluating derby as alternative db for
> my app, however I found in the docs that no
> BIT/BOOL/BOOLEAN data type in derby. Am I missing it
> out ? this is strange because in most database there
> must be a native datatype that holds 0, 1 or TRUE,
> FALSE.
> any idea ?

I did some research a while ago and found very little support for the
BOOLEAN datatype across databases, did I miss something?

IBM DB2 UDB 7/8 - not supported
Informix - BOOLEAN supported
MySQL 4.0 - not supported
Oracle 9/10 - not supported
Postgres 7.4 - BOOLEAN supported
SQL Server 2000 - not supported

(I was looking at databases that one might migrate a Derby application to)

http://www-106.ibm.com/developerworks/forums/dw_thread.jsp?message=4102747&cat=19&thread=59731&forum=370#4102747

Dan.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBwFGkIv0S4qsbfuQRAh0oAJ9owwCm3xOwI/7T+ZVkvI87utqSFwCgp0Ll
s/ES7K+oNe2elDv6lhHdxN0=
=gNSo
-----END PGP SIGNATURE-----


Mime
View raw message