-----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-----
