Oracle-L: RE: How can we make any column of a table as case insensitive

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Wed, 17 Apr 2002 20:53:29 -0800
Message-ID: <F001.004477A5.20020417205329@fatcity.com>

Can you post what requiremment is driving this? I.E. Is it to be able to query for a mixed-case input value? Maybe to sort mixed case as if it were all upper or lower?

Tony Aponte

-----Original Message-----
Sent: Tuesday, April 16, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L

Greetings All,

We have a requirement of making one or multiple or all columns of a table case insensitive. We can not modify the query as it comes from a 3rd party application. One option I can think of is that introduce a trigger on the table and before inserting or modifying the column's data force it to be all uppercase or all lowercase.

Is there any other way of doing it? Can we do it using a constraint?

This requirement is like the feature of ic(ignore case) in vi editor.

Thanks,
Ashoke
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mandal, Ashoke
INET: ashoke.k.mandal_at_medtronic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Aponte, Tony
INET: AponteT_at_hsn.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------