Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting for case-insensitve comparison
Purzel71 wrote:
>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
>
>
Oracle prior to 10g is always case sensitive. Workarounds are function
based indexese
and the use of functions such as UPPER and LOWER.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Nov 07 2003 - 00:07:54 CST