Hi,

AFAIK VARCHAR() as well as CHAR() values are stored and returned
correctly without truncating or adding spaces. The 'oddity' with
UNIQUE KEY constraints relates to the SQL standard, which dictates the
removal of trailing spaces before comparison, so that 'abc' and 'abc '
are evaluated as equal and provoke a UNIQUE KEY violation.

Regards,

Christian