db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: Case-Insensitive Unique Constraint
Date Thu, 17 Jan 2008 15:56:27 GMT
Sai Pullabhotla wrote:
> Rick, 
>
> Thanks for the advice on using a CHECK constraint. It surely helps ensuring
> the data integrity. 
>
> Otherwise, I think this is very basic feature that every one would like to
> see, and it would help if Derby can handle this automatically using the
> Computed/Generated columns or allowing UNIQUE index creation using
> UPPER/LOWER. 
>   
Another alternative would be to allow a collation to be specified when 
creating an index.

Mark Thornton


Mime
View raw message