Re: case-insensitive foreign key

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.

HTH,
Brian

Branko Milosavljevic wrote:
>
> Hi all,
>
> I am porting a database from MS SQL Server to Oracle8i, and having
> trouble with the data that relies on SQL Server's case-insensitive
> foreign keys/indexes. Is there a way to achieve this functionality in
> Oracle?
>
> I have read about function-based indexes (such as ...UPPER(ename)) and
> case-insensitive searches, but can they be used for referential
> integrity constraint checking? Is there any other way to accomplish
> this?
>
> Thanks,
> Branko Milosavljevic

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"