Bug #38885 a japanese character make sql bad

Description:
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
insert into `user` set name='

How to repeat:
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
insert into `user` set name='

the sql file

Attachment: query.sql (application/octet-stream, text), 362 bytes.

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
insert into `user` set name='

detail for the problem

Attachment: detail.txt (text/plain), 1.25 KiB.

it seems the database of mysql.com also have those problem... my comment which i sent been truncated,poor.....

Thank you for the report.

If I understood correctly problem character is 4-byte: F0A0AEB7. MySQL supports such character since version 6.0. Please upgrade.

Many thanks for writing a bug report.

Unfortunately, this is not a bug.

MySQL only supports 3 byte characters but the character you used here is a 4 byte character.

http://dev.mysql.com/doc/refman/5.1/en/charset-unicode.html

"Currently, MySQL support for UTF-8 does not include four-byte sequences."