Alan wrote:
>>But as I doubt you will let me give you the answer ... there is not
>>a single valid reason I can think of in Oracle to ever use a CHAR
>>column. And performance is only a small part of the reason.
>>
>
>
> This is not a valid reason, but I use CHAR(1) in place of the non-existant
> Boolean (no, I don't want to argue about the need for Boolean data), or
> maybe for a flag. Just for ease when scanning designs and so on.
But do keep in mind that 0 and 1 would be more efficient for that purpose.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat Jun 12 2004 - 15:11:39 CDT
