Bug #21936 create table faile when engine=innodb,column name use chinese charset
Submitted: 31 Aug 2006 2:37 Modified: 30 Sep 2006 11:08
Reporter: justin he Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:5.0 OS:Windows (windows)
Assigned to: Assigned Account CPU Architecture:Any

[31 Aug 2006 2:37] justin he 
Description:
create table faile when engine=innodb,column name use chinese charset gb2312,

use query browser to create, and SQL like following:

CREATE TABLE `test`.`t2` (
  `号码` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `姓名` VARCHAR(45) NOT NULL,
  PRIMARY KEY(`号码`)
)
ENGINE = InnoDB
CHARACTER SET gb2312 COLLATE gb2312_bin;

How to repeat:
install mysql-5.0.24 community version on window XP professinal sp2 chinese version,
install mysql-gui-tools-5.0-r2-win32.msi,

then use MySQL Query Browser to create a table in test schema, if engine=innoDB,
column name use chinese char, charset use gb2312,

create talbe will fail, and error number is 1064
[31 Aug 2006 11:08] Valeriy Kravchuk 
Thank you for a problem report. Please, try to repeat with mysql command line client and ifnorm about the results. I have to check is it server problem or Query Browser one.
[12 Sep 2006 9:40] Heikki Tuuri 
This is probably a Query browser bug or wrong settings in the computer.

heikki@127:~/mysql-5.0/include$ grep -n 1064 *.h
mysqld_ername.h:67:{ "ER_PARSE_ERROR", 1064 },
mysqld_error.h:68:#define ER_PARSE_ERROR 1064
[1 Oct 2006 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".