Re: How to make Oracle case insensitive?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 5 Nov 1999 23:46:52 +0100
Message-ID: <941842059.13882.0.pluto.d4ee154e@news.demon.nl>

create a pre-insert trigger and do a :new.MyCol := upper(:new.MyCol)

--
Sybrand Bakker, Oracle DBA
Gennady <gennadyb_at_halcosoftware.com> wrote in message news:38235b35$0$30803_at_fountain.mindlink.net...
> Hello,
> I have a table with MyCol column as primary key:
>
> MyCol
> ______
> US
> UK
>
> How can I prevent a user to put data like this:
>
> MyCol
> ______
> US
> UK
> us
>
> Thanks,
> Gennady
>
>
Received on Fri Nov 05 1999 - 16:46:52 CST