"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.
No. You would typically (8iEE or greater) use a function based index on
either UPPER or LOWER function and rewrite your sql to use the relevant
function, or (< 8i or std edition) create an extra column in your table to
hold the uppercase version of your column and maintain this column through a
trigger. you would then rewrite the sql to query the extra column.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
Received on Wed Nov 05 2003 - 06:28:07 CST
