Also, be sure to add a check constraint to limit entries to 0 or 1. --- Kathey Marsden <[EMAIL PROTECTED]> wrote:
> -----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----- > ===== The only "dumb question" is the one you were too afraid to ask. ________________________________________ Check out RouteRuler - Free software for runners, cyclists, walkers, etc. http://routeruler.sourceforge.net ________________________________________ Get a handle on your data with "pocOLAP", the "little" OLAP project http://pocolap.sourceforge.net ________________________________________ __________________________________ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250
