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:05:15 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The constraint may be a good idea, but also getBoolean() will return
true for any non-zero value, not just 1.

Dan.


todd runstein wrote:
> Also, be sure to add a check constraint to limit
> entries to 0 or 1.
>
> --- Kathey Marsden <kmarsden@Sourcery.Org> wrote:

>>Your best bet is to use SMALLINT and insert a 1 or
>>0.
>>rs.getBoolean(i) will return true for 1, false for
>>0.
>>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBwFKrIv0S4qsbfuQRAo4jAKDiurdq/RKiVGxfg/3d11Ji4JTwWQCgta7s
fNgtUVcu1rOUbrDHsOmIL4Q=
=kwOl
-----END PGP SIGNATURE-----


Mime
View raw message