我用的是Mysql5.5.15的版本,Archive数据库引擎,utf-8的编码方式在设置主键的时候出现ERROR 1071: Specified key was too long; max key length is 8 bytes这样的错误,具体如下:本人初次接触Mysql具体什么问题还不是很清楚请高手帮帮忙!!!
ERROR 1071: Specified key was too long; max key length is 8 bytesSQL Statement:CREATE TABLE `test`.`new_table` ( `stuId` VARCHAR(128) NOT NULL , `stuName` VARCHAR(45) NOT NULL , PRIMARY KEY (`stuId`) )ENGINE = ARCHIVEDEFAULT CHARACTER SET = utf8
ERROR 1071: Specified key was too long; max key length is 8 bytesSQL Statement:CREATE TABLE `test`.`new_table` ( `stuId` VARCHAR(128) NOT NULL , `stuName` VARCHAR(45) NOT NULL , PRIMARY KEY (`stuId`) )ENGINE = ARCHIVEDEFAULT CHARACTER SET = utf8
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货