Subject Re: [firebird-support] Unique index that allows difference in trailing whitespace?
Author Ivan Přenosil
> I have a table that contains a varchar and there is a unique constraint
> on that varchar column.
>
> My problem is that I would need the table to allow values that differ
> (only) in trailing whitespace.
...
> Is there any better way to solve this, than using a unique computed
> index on the expression varcharcol || '.' or something similar?

Other possibiliy is to define the column with character set OCTETS.

Or add column containing lenght of field and use both data+length columns
in your constraint.

Ivan