修改表
alter table USER convert to charset utf8mb4, character set utf8mb4;
修改列
ALTER TABLE USER DEFAULT CHARACTER SET utf8mb4,
modify REALNAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
modify REALNAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
SHOW FULL COLUMNS FROM `user` ; 这个是检查当前编码
show CREATE TABLE USER; 查看表编码
show VARIABLES LIKE '%char%'
rename table abc to ABC
mysql 配置文件配置详解
http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_character-set-client-handshake
mysql数据库5.5以上版本支持utf8mb4
同时配置文件采用utf8mb4设置
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
[client]
default-character-set = utf8mb4
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
[client]
default-character-set = utf8mb4
mysql表大小写问题
http://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html