Subject RE: [IB-Architect] Syntax for case insensitive sort
Author Matt Larsen
Jim Starkey said:
>I'm not very comfortable with the combination of case insensitivity
>and unique contraints. They seem a little unnatural. We could
>invent some rules, but it strikes me as unwise.

If we allow the case sensitivity to be set by field on the index, then this
is a database design issue. A unique index with case insensitive fields
should be straight forward to implement on the engine.

Matt Larsen