RE: case sensitivity - database setting?

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 8 Aug 2005 18:53:37 +0200
Message-Id: <20050808165340.6590A1DD3AF@turing.freelists.org>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex
Sent: Monday, August 08, 2005 18:41
To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 08 2005 - 12:45:45 CDT