Re: make oracle case insensitive?

I've seen in SAP tables that they hold some values double, once as the user typed it, and a second column with the same value all in uppercase, case insensitive queries can then be done on the later, using indexes, ... you'll have to set up some triggers/... to populate and maintain the values in that all uppercase column ...

"Eric" <staceye_at_picknowl.com.au/NOSPAM> wrote in message news:3ae45b17_at_newsserver1.picknowl.com.au...
> Hi,
> How do you set up Oracle so that it is case insensitive?
> eg
> select xyz from abc where xyz = 'XXX';
> will return the same values as
> select xyz from abc where xyz = 'xxx';
> This is how it works at my Uni and I would like my Oracle to behave the
> same.
> I am using Oracle 8i Personal on Win2000;
> Thanking you in advance
> regards
> Eric.
> PS have tried sql help and search at Oracle but had no luck.
>
>
>
Received on Sat May 05 2001 - 13:51:18 CDT