make oracle case insensitive?
From: Eric <staceye_at_picknowl.com.au/NOSPAM>
Date: Tue, 24 Apr 2001 02:11:25 +0930
Message-ID: <3ae45b17_at_newsserver1.picknowl.com.au>
Date: Tue, 24 Apr 2001 02:11:25 +0930
Message-ID: <3ae45b17_at_newsserver1.picknowl.com.au>
Hi,
[Quoted] 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 Mon Apr 23 2001 - 18:41:25 CEST