windows为my.ini或者my-default.ini(linux配置文件my.cnf,在/etc目录)
找到后请在以下三部分里添加如下内容:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
重启服务,查询一下
show global variables like '%char%';
是不是如下造型
关键的来了,修改相应表字段,支持emoji:
alter TABLE topic_video_comment modify `comment` VARCHAR(500) CHARACTER set utf8mb4 COLLATE utf8mb4_unicode_ci null COMMENT '回复内容';
OK,perfect
下面虽然能改变当前的字符集,但是好像没作用…………暂时也展示出来吧!
SHOW VARIABLES WHERE Variable_name LIKE 'character%' OR Variable_name LIKE 'collation%';
set character_set_client = 'utf8mb4';
set character_set_connection = 'utf8mb4';
set character_set_database = 'utf8mb4';
set character_set_results = 'utf8mb4';
set character_set_server = 'utf8mb4';
set collation_connection = 'utf8mb4_unicode_ci';
set collation_database = 'utf8mb4_unicode_ci';
set collation_server = 'utf8mb4_unicode_ci';