Re: case-insensitive foreign key

From: Branko Milosavljevic <mbranko_at_uns.ns.ac.yu>
Date: 21 Sep 2003 11:02:38 -0700
Message-ID: <19b4eb25.0309211002.479f2e84@posting.google.com>

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.
>
Received on Sun Sep 21 2003 - 13:02:38 CDT