I'm not sure where that came from, however I'm sure its somewhere on the wish
list.
Since the boolean type has been around for a while, and its implemented in
other databases, its not out of the realm of being added.
With respect to java objects, what are they?
Note: that was a rhetorical question.
The point being is that one can define a boolean data type in terms of how to
store it within a database.
POJOs are a different story.
Before you think about java objects, you're going to want to redesign derby
itself .
But that's a different issue.
Sent via BlackBerry.
-Mike Segel
Principal
MSCC
312 952 8175
-----Original Message-----
From: "Bayless Kirtley" <[EMAIL PROTECTED]>
Date: Thu, 7 Dec 2006 09:20:07
To:"Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Best choice for column's data type to represent boolean data
Is there reason to think the next version may support Boolean data type?
If so then what about Java Objects?
Bayless
----- Original Message -----
From: "Leslie Software" <[EMAIL PROTECTED]>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Thursday, December 07, 2006 8:07 AM
Subject: Re: Best choice for column's data type to represent boolean data
Thanks for the advice I was leaning towards the numeric solution but using
'T' / 'F' as a visual clue makes a lot of sense. After all until we do have
a new boolean data type that visual clue is all we have. I am already
looking forward to the next version:-)
Ian
----- Original Message ----
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Well the best practice would be to extend the known data types to include a
Boolean. ;-)
There are two options.
You can create a CHAR(1) column, or if the database you could do a
byte/short column as well.
If you use a CHAR(1) you could represent the Boolean as either ('T' or 'F')
or ('Y','N'). You would also want to put a check constraint on the column
only allowing a true and a false value.
You could also use a 1 or a 0 in the column as well and provide the same
check constraint, however using a T/F or Y/N provides a visual cue that
would be missing from a numeric solution.
HTH
-G
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
