指定的键太长;最大密钥长度为1000字节 [英] Specified key was too long; max key length is 1000 bytes
本文介绍了指定的键太长;最大密钥长度为1000字节的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
importimg Joomla 1.5数据库通过mySQL转储但它给出错误1071 - 指定的键太长;最大键长度是1000字节
importimg Joomla 1.5 database via mySQL dump but it gives error "1071 - Specified key was too long; max key length is 1000 bytes"
culrpit sql语句:
the culrpit sql statement is:
CREATE TABLE `jos_core_acl_aro` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`section_value` VARCHAR( 240 ) NOT NULL DEFAULT '0',
`value` VARCHAR( 240 ) NOT NULL ,
`order_value` INT( 11 ) NOT NULL DEFAULT '0',
`name` VARCHAR( 255 ) NOT NULL ,
`hidden` INT( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY ( `section_value` , `value` ) ,
KEY `jos_gacl_hidden_aro` ( `hidden` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =11;
MySQL said:
#1071 - Specified key was too long; max key length is 1000 bytes
目标数据库为UTF8。我仍然不知道为什么会出现这个错误:(
The source & destination database is UTF8. I still don't know why this error occurs :(
推荐答案
mysql将utf8编码的字符存储为3个字节
mysql stores utf8 encoded chars as 3 bytes
您的金钥
UNIQUE KEY ( `section_value` , `value` ) ,
大小为(240 + 240)* 3个字节,大于1000个限制
has a size of (240 + 240) * 3 bytes, which is greater then 1000 limit
这篇关于指定的键太长;最大密钥长度为1000字节的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文