Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: case sensitivity - database setting?
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex
Sent: Monday, August 08, 2005 12:41 PM
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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 08 2005 - 12:23:13 CDT