Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Using Index for case insensitive search
You probably could create function indexes
see http://govt.oracle.com/~tkyte/
or use interMedia to fully index the columns
>I hope this is the correct forum for this question,
>
>I am using oracle 8i and I need to do some searching by city or
>companyname. Currently, the text entered into these fields vary in
>case. I would like the results to be displayed in a case insensitive
>manner, however there are thousands of records and an index is required
>for performance issues. Both of these fields have indexes. Is there a
>way to create a case insensitive index? I am trying to avoid using
>triggers to create uppercase fields just so that I can use a case
>insensitive index. Any suggestions?
>
>Thanks in advance,
>
>Chris Bruce
>
>
Received on Tue Jul 11 2000 - 00:00:00 CDT