I have a table with a TEXT field called "username". I'd like to retain the
case of the data stored here, but I'd like all comparisons to be done without
regard to case. Since all these accesses _should_ be done through database
functions, I can simply lower() the input values and compare. I also have
an index created on lower(username), so lookups are quick.
However, I'd also like to have some sort of table constraint to make sure
alternate case "duplicate" records don't creep into the table. Any tips?
--
Shaw Terwilliger <sterwill@sourcegear.com>
SourceGear Corporation
217.356.0105 x 641