How to disable auto truncation of char binary column

bump

Leif Wessman wrote:
 > Why is a single space truncated in the following example?
 >
 > Leif
 >
 > alter table CURRENCY
 > change column THOUSANDS_SEP THOUSANDS_SEP char(1) binary not null
 > , type=MyISAM
 >
 > UPDATE CURRENCY SET THOUSANDS_SEP = ' ' WHERE NAME = 'SEK'
 >
 > SELECT LENGTH(THOUSANDS_SEP) AS L FROM CURRENCY WHERE NAME = 'SEK'
 > Result: L = 0