db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmars...@Sourcery.Org>
Subject Re: No BIT/BOOLEAN Data Type in Derby?
Date Wed, 15 Dec 2004 12:29:34 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 ?
>
Your best bet is to use SMALLINT and insert a 1 or 0.
rs.getBoolean(i) will return true for 1, false for 0.

Kathey

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

iD8DBQFBwC4uG0h36bFmkocRApMgAJ4ryUsS2fRxXf8wM+1aARbQeWMv3gCfa8mc
1q44VLSOP2f0gBEmwaPDh7c=
=psv7
-----END PGP SIGNATURE-----

Mime
View raw message