Re: which column type char,varchar2 is better for index?

In line...

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:cahduf$8s8$1_at_sparta.btinternet.com...
>
> Note in-line.
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1087071115.755274_at_yasure...
> >
> > > 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.
> >
> It sounds like a perfectly valid reason to me.
> Standards that do no harm and add clarity to
> structure and code are always valid.
>

Thanks! I was wimping out so as not to get into a protracted technical discussion as to whether or not it was a valid reason. Obviously *I* think it is a valid reason or I wouldn't be doing it. :) Received on Mon Jun 14 2004 - 14:31:39 CDT