Re: Searching case-insensitively

Simon Mercer <mercer_at_mpimg-berlin-dahlem.mpg.de> wrote:

>Well, so far I know that if I use functions I can't use indices, and
>that there is no other way to switch to a default case-insensitive
>searching behaviour. Forcing text entry in uppercase is not an option
>because case has meaning in these text strings.
>
>So there's no way to do this (unless someone knows different)....
>
>Surely this is a MASSIVE shortcoming in Oracle, or am I the first person
>in the world who needs an efficient case-insensitive search?

One possible solution, though not a very elegant one, is to create an upper case name column in addition to the mixed case one and index that.

That's the only thing I can think of till oracle either gives us the option of a case insensitive b-tree algorithm, or indexed computed columns.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!