Subject Re: [firebird-support] How to create a string column with significant trailing spaces
Author Ann W. Harrison
Thekla Damaschke wrote:
> That is not really true, the standard defines a property
> "PAD SPACE" or "NO PAD" for collations

You're absolutely right, a collation can be declared with the
NO PAD attribute, which causes a shorter string that matches
the prefix of a longer string to be considered less than the
longer string. Sigh. Live and learn. And, it appears that
Firebird2 recognizes the NO PAD attribute on collations, so
that may in fact be a solution.