db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Case-Insensitive Unique Constraint
Date Tue, 15 Jan 2008 23:38:26 GMT
> Is there a way to create a unique constraint/index which ensures the
> uniqueness of data IGNORING the case? 

One idea would be to store the data twice, in two separate columns:
  - in one column, store the data normally, in the case as provided
  - in the other column, store the data in all upper case

Then create a unique index on the all-upper-case column.

thanks,

bryan



Mime
View raw message