Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: case-insensitive foreign key
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