HELP - CASE SENSITIVITY

From: Chris Gadsby <chris_gadsby_at_compuserve.com>
Date: Wed, 17 Jun 1998 14:45:01 -0400
Message-ID: <01bd9a21$2d014c60$1d01ab9f@cjgnote>

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 Wed Jun 17 1998 - 13:45:01 CDT