Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: make oracle case insensitive?
One way is to use the UPPER function on both sides of your query ( or the InitCap or Lower functions - this will be slow unless you can create a function-based index on the search column ( that ability is Oracle version dependant) )
Like
select xyz from abc where upper(xyz) = upper('xxx');
Another way is to force the contents of the fields to all upper case with a trigger or a form constraint...
"Eric" <staceye_at_picknowl.com.au/NOSPAM> wrote:
>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:49:27 CDT