Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case insensitive comparisons - no way?
Yep that's how bubba did it until he traded in the camaro and the low-profile tires for an enterprise edition.
"John Jones" <john.jones_at_duke.edu> wrote in message
news:8gbem7$n11$1_at_news.duke.edu...
> Actually, before Oracle 8i, I would suggest all coulmns be stored in all
> CAPS. That makes searching easier. You can always display to the screen
or
> reports in any format that you want.
>
> --
> John Jones
> Senior Oracle DBA
> Duke University OIT
> john.jones_at_duke.edu
> Alexander Jerusalem <ajeruNOajSPAM_at_gmx.net.invalid> wrote in message
> news:125b7ef1.2125739b_at_usw-ex0108-063.remarq.com...
> > Thank you for your answer Mark.
> >
> > Unfortunately I can't use the OR trick you are suggesting because
> > most of the fields I have to deal with are names. Names of
> > institutions, names of people, nick names, titles of books and
> > magazines and so on. Everything will be in mixed case and must
> > stay in mixed case for display on the screen and on reports.
> >
> > So I guess my only option is to store all the fields twice, once
> > for display and once for the queries. That's awful.
> >
> > My other choice obviously is to go back to Microsoft SQL Server
> > which I had hoped to have left behind forever.
> >
> > --------------------
> > Alexander Jerusalem
> > VKN
> > ajeru_at_gmx.net
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network
*
> > The fastest and easiest way to search and participate in Usenet - Free!
> >
>
>
Received on Mon May 22 2000 - 00:00:00 CDT