If you need extra spaces at each end of the string, place quotes around
the
whole string and remove them again when retrieving the data.
/ Carsten
Faisal Nasim wrote:
>
> : >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.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread15265@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
