Commented by: @aafemt

SQL standard: collations have "PAD" attribute by default.

Commented by: Alexander Muylaert (alexander_gonline.be)

Thanks

For the sake of documentation if somebody pops up on this question

https://crate.io/docs/sql-99/en/latest/chapters/22.html

A Collation's PAD characteristic affects the result when two strings of unequal size are compared. If the Collation in effect for a comparison has the PAD SPACE characteristic, the shorter string is padded with spaces (on the right) until it's the same length as the larger string; then the comparison is done. If the Collation in effect for a comparison has the NO PAD characteristic, the shorter string is padded with some other character before the comparison is done. In this case, the result is that the shorter comparand will evaluate as less than the longer comparand if they contain the same characters for their common length - see our chapter on character strings.

Commented by: Alexander Muylaert (alexander_gonline.be)

Out of curiosity

Isn't a comparison of a string of 3 chars with a string of 6000 chars then a horrible thing?

I don't very often use this kind of string stuff, but most people do have an index on zip or email somewhere in their project...

Commented by: @mrotteveel

This isn't a suitable topic for the tracker. Please post your question to firebird-support.