two method: 1. don't use UTF-8 as default character-set of mysql server, use latin1
or
2. don't use MYISAM as table type, please convert to INNODB myisam has a limit for key, it's 1K long.
vi /etc/my.cnf
[mysqld]
default_table_type = InnoDB
character-set-server=utf8 init_connect=’SET NAMES utf8′
two method:
1. don't use UTF-8 as default character-set of mysql server, use latin1
or
2. don't use MYISAM as table type, please convert to INNODB
myisam has a limit for key, it's 1K long.
vi /etc/my.cnf
[mysqld]
default_table_type = InnoDB
character- set-server= utf8
init_connect=’SET NAMES utf8′