Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case insensitive comparisons - no way?
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...Received on Mon May 22 2000 - 00:00:00 CDT
> 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!
>