Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting for case-insensitve comparison
"Purzel71" <kiedoni_at_spamfresser.de> wrote in message
news:boajuk$4ep$07$1_at_news.t-online.com...
> Hi,
>
> is there any setting for the Oracle Server for case-insensitive string-
> comparison.
>
> At the moment we have a software that passes something like
> "select * from foo where something like 'ABC'". The resultset does not
> contain records with "abc".
>
> Is there any configuration-file to set string-comparision to case-
> insensitive.
>
> Thanx in advance,
>
> Purzel
where upper(something) = 'ABC'
you'll need a function based index on upper(something) to get any
performance on a large table.
Received on Wed Nov 05 2003 - 05:28:59 CST