db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From todd runstein <todd_...@yahoo.com>
Subject Re: No BIT/BOOLEAN Data Type in Derby?
Date Wed, 15 Dec 2004 13:39:15 GMT
Also, be sure to add a check constraint to limit
entries to 0 or 1.

--- Kathey Marsden <kmarsden@Sourcery.Org> 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

Mime
View raw message