Re: Help Case Sensitivity

Chris,

The only thing I can suggest is to use the TOUPPER or TOLOWER function in your query , i.e.:

        SELECT * FROM Table WHERE TOUPPER(col) = 'A';

I don't know if this is an Oracle specific SQL extension or ANSI. The downside of doing this is that if the column has an index on it, the index gets clobbered, so you get a sequential search which can cause a severe performance impact. In that case I've added another column that is the search column translated into Upper case, which I then indexed.

Hope this helps,
Hank Talbot

On Wed, 17 Jun 1998 14:45:49 -0400, "Chris Gadsby" <chris_gadsby_at_compuserve.com> wrote:

>Hi,
>
>
>Is there any way to make an oracle database case insensitive? (ie where
>col = 'A' will find the same set as where col = 'a' )
>
>It would be of immense help of I could do this some how without having to
>rewite the client applications to force the data into all upper case or
>something. I'm looking for some sort of compatability with Sybase / SQL
>Server which can be set to be case insensitive.
>
>Pleae help if you can!
>
>Thanks
>
>Chris Gadsby
Received on Sat Jun 27 1998 - 08:17:53 CEST