Re: upper case constraint?

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 21 Feb 2004 14:33:20 GMT
Message-ID: <Q_JZb.15735$dS2.13572@newssvr29.news.prodigy.com>

D. Alvarado wrote:

 > Hello, I'm working with Oracle 8.1.7 for Solaris.  Is there any
 > constraint I can put on a VARCHAR2 column to force its characters
 > always be stored as upper case?  Thanks - Dave

Niall Litchfield wrote:

> the check constraint will work, but throw an error back to the user. an
> alternative uses a trigger
>
>

[...]

And further, if all you want to do is efficiently search the column using upper case, regardless of what the user entered into it, then a function based index could be used.

--Mark Bole. Received on Sat Feb 21 2004 - 08:33:20 CST