RE: case sensitivity - database setting?

Check out the Oracle REGEXP_% functions. they support an option for
case-insensitive searching.

in Oracle10g, you can set the NLS_SORT parameter to a value ending with _CI (for
Case Insensitive) to change the default sorting behavior. If you then *also* set
the NLS_COMP parameter to ANSI (instead of the default value BINARY) the WHERE
clause comparisons will use the NLS_SORT setting, and become case independent
too.

kind regards,

Lex.
 
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of J. Dex
Sent: Monday, August 08, 2005 18:41
To: oracle-l@xxxxxxxxxxxxx
Subject: case sensitivity - database setting?

We are setting up an application (third-party out-of the-box type) and the group
that is setting it up would like to set it up so that when users search for
records the searches are NOT case sensitive.
Is there an Oracle database setting that would facilitate this?  The application
vendor said it is a database issue and has to be set on the database side.

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD

Other related posts: