| Subject | Re: [firebird-support] How to create a string column with significant trailing spaces |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2006-08-29T16:51:59Z |
Thekla Damaschke wrote:
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.
Regards,
Ann
>You're absolutely right, a collation can be declared with the
> That is not really true, the standard defines a property
> "PAD SPACE" or "NO PAD" for collations
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.
Regards,
Ann