RE: case sensitivity - database setting?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Aug 2005 13:21:14 -0400
J. Dex,
As you can see from some of the replies, Oracle does not provide this
automatically for you. It will take coding changes to get this to
happen.
A simple change for an individual table is as follows:
Table Name_Table
Last_Name varchar2(30);
First_Name varchar2(30);
Name_Sort varchar2(60);
And a simple database trigger like this:
On Insert or Update
Name_Sort := Upper(Last_Name || ' ' || First_Name);
You can then sort by the Name_Sort column all day long.
Not the answer you were looking for, but a simple workable one.
Good Luck.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Monday, August 08, 2005 12:41 PM
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
