#4408 If enum item use Chinese character, phpMyAdmin cannot show table structure.

[bytecoin]

If enum item use Chinese character, phpMyAdmin cannot show table structure.

My table structure:

CREATE TABLE IF NOT EXISTS bytecoin_reward (
reward_id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '奖励编号',
user_id int(10) unsigned NOT NULL COMMENT '用户编号',
reward_type enum('注册','充值','绑定邮箱','绑定手机','绑定QQ','邀请注册','邀请充值','邀请加群','发论坛','发百度知道','发百度贴吧','其他') NOT NULL,
reward_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '奖励时间',
reward_rmb decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '人民币奖励',
reward_byc decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '百特币奖励',
reward_operater int(10) unsigned DEFAULT NULL COMMENT '奖励发放人',
reward_remark varchar(255) DEFAULT NULL COMMENT '备注',
reward_remark2 int(11) DEFAULT NULL COMMENT '备注2，邀请注册和充值奖励为用户ID，发论坛奖励为发帖数，QQ邀请奖励为邀请用户数',
PRIMARY KEY (reward_id),
KEY fk_reward_operater (reward_operater),
KEY fk_reward_user_id (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='奖励表' AUTO_INCREMENT=3 ;

[bytecoin]

Simplified table structure:

CREATE TABLE IF NOT EXISTS bytecoin_reward3 (
reward_id int(10) unsigned NOT NULL AUTO_INCREMENT,
reward_type enum('注册','充值','绑定邮箱','绑定手机','绑定QQ','邀请注册','邀请充值','邀请加群','发论坛','发百度知道','发百度贴吧','其他') NOT NULL,
PRIMARY KEY (reward_id))

[bytecoin]

Sorry, I found 4.2.1 have fixed this problem.