Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Implementation of boolean types.

Re: Implementation of boolean types.

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 14 Jul 2005 23:53:30 +0200
Message-ID: <42d6dedb$0$16560$ba620e4c@news.skynet.be>

"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:db6cjj$obt$2_at_news1.zwoll1.ov.home.nl...
> Matthias Hoys wrote:
>>
>> I would use a CHAR(1) column with a check constraint ('0' or '1').
>> You could then link the table to a small lookup table with the
>> description
>> of the 0 and 1.
>> 0 = male
>> 1 = female
>>
>
> No.
> That would be '0' for male, and '1' for female. Character strings!
>
>
> Why would you use a depericated char datatype, and not
> a number?
>
> --
> Regards,
> Frank van Bortel

CHAR(1) takes up less space ? Received on Thu Jul 14 2005 - 16:53:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US