Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> make oracle case insensitive?

make oracle case insensitive?

From: Eric <staceye_at_picknowl.com.au/NOSPAM>
Date: Tue, 24 Apr 2001 02:11:25 +0930
Message-ID: <3ae45b17@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 Mon Apr 23 2001 - 11:41:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US