1. 修改my.cnf
character-set-server=utf8mb4
default-character-set=utf8mb4
修改后重启Mysql
2.修改表名
alter table TABLE_NAME convert to character set utf8mb4 collate utf8mb4_bin; (将TABLE_NAME替换成你的表名)
3.修改字段
ALTER TABLE g_comment CHANGE content content VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;