DATE_FORMAT function with ucs2 collation

[Jean-Pierre Morfin]

Hello,

I encounter some trouble with a full usc2_bin MyISAM database (MySQL 5.0.24).

CREATE TABLE `thetable` (
`thekey` varchar(16) collate ucs2_bin NOT NULL default '',
`thecolumn` varchar(8) collate ucs2_bin NOT NULL default '00000000',
PRIMARY KEY (`thekey`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;


When I execute a request like this one :

INSERT INTO `thetable` ( `thekey` , `thecolumn` )
VALUES ('1', DATE_FORMAT(NOW(), '%Y%m%d'))

I obtain a very strange result in 'thecolumn' (exotics characters) such ㈰〶ㄱ〷

Do you know why ?

Many thanks