Re: Help! Case Insensitive Unique Indexes and PKs

From: Douglas White <douglas.white_at_dial.pipex.com>
Date: Thu, 5 Nov 1998 19:35:58 -0000
Message-ID: <71surb$9qj$1@plug.news.pipex.net>

>Hi,
>
>is there a specific reason for not using a numeric PK ?????
>
>that should solve your case sensitivity problem
>
>Regards
>--
>Oliver Willandsen
>European Commission
>http://europa.eu.int

I want to prevent user's from entering the same alpha numeric data regardless of case.
e.g. if PK=currencyname then don't allow user to enter one record with value "Dollar" and then another with value "DOLLAR". I want this to raise a key violation error. Received on Thu Nov 05 1998 - 13:35:58 CST