db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sai Pullabhotla" <Sai.Pullabho...@jMethods.com>
Subject Case-Insensitive Unique Constraint
Date Tue, 15 Jan 2008 23:22:33 GMT
Hello every one, 

I'm in the process of porting an application from HSQLDB to Derby. I ran
into an issue with defining unique constraints on character (CHAR and
VARCHAR) data IGNORING the case. HSQLDB has a proprietary data type called
"varchar_ignorecase" and we have used that extensively. However, there is no
such thing in Derby that could find. So my questions are: 

Is there a way to create a unique constraint/index which ensures the
uniqueness of data IGNORING the case? 

What I mean by above is - trying to insert "derby" when "Derby" already
exists in the table should produce a constraint violation error. 

I've gone through the documentation and Googled for several hours, but could
not find anything to accomplish this. 

If there is no direct way to do this, what would be the best

Any help would be greatly appreciated. 

Sai Pullabhotla
jMethods, Inc. 
Phone: +1 (402) 408-5753 
Fax: +1 (402) 408-6861

View raw message