|Subject||Re: [firebird-support] Case insensitive Insert with Unique Column|
>> Is there a way to prevent a Insert, if a unique column contains theJust a note. In Firebird 2.x, one could create an UNIQUE expression
>> same word which is to insert but only in upper chars ?
> Add another column, a varchar of the same size, and place the unique index on it, not on the mixed case column.
> Have a Before Insert trigger to populate the "case insensitive" column:
> if (new.MixedCaseColumn is not null) then
> new.CaseInsensitiveColumn = UPPER(new.MixedCaseColumn);
> Of course, if MixedCaseColumn is non-nullable, the null test isn't required.
index with UPPER on the field in question.
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and