Re: Trailing blanks get chopped away from 'strings'

[Faisal Nasim]

: >Description:
: I have some strings ending with blank characters. They are
: efficiently removed. The trailing blanks are relevant.

According to the doc:

CHAR(M) [binary]  A fixed length string that is always filled up with spaces
to the specified length. Range 1 - 255 characters. All end space are removed
when retrieved. Is sorted and compared case insensitively unless the binary
keyword is given.  M

VARCHAR(M) [binary]  A variable length string that is stored with its
length. All end space are removed when storing it. Maximum range 1 - 255
characters. Is sorted and compared case insensitively unless the binary
keyword is given.