Re: Case-Insensitive Unique Constraint

[Bryan Pendleton]

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