Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: case-insensitive foreign key

Re: case-insensitive foreign key

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 21 Sep 2003 21:40:34 -0700
Message-ID: <1064205623.287844@yasure>


Branko Milosavljevic wrote:

>Well, I have a legacy database (from MS SQL Server) that has used this
>feature. Of course, I can convert all data to upper/lowercase but
>users are accustomed to use this case insensitivity. So the question
>really was "Is there a way to build a referential integrity constraint
>on char or varchar2 columns that is case-insensitive?"
>
>Best regards,
>Branko
>
>Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F69C67D.123A926_at_remove_spam.peasland.com>...
>
>
>>On top of the other good advice....a tactic you may wish to employ is to
>>force the data to be all either upper case or all lower case,
>>effectively removing the case sensitivity from the issue. You can do
>>this with a trigger on the appropriate tables to convert the data when
>>it is inserted or updated.
>>
>>
>>

And the answer as printed in this usenet group hundreds of times is FBI ... Function Based Indexes. And if you
can't do that explicit conversion using the UPPER or LOWER built-in functions.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Sep 21 2003 - 23:40:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US