设置mySql的编码方式为utf-8

检查命令:

mysql> show variables like '%char%';

期望结果:

使用mysql命令设置:

如果仍有编码不是utf8的,请检查配置文件,也可使用mysql命令设置:

set character_set_client = utf8;

set character_set_server = utf8;

set character_set_connection = utf8;

set character_set_database = utf8;

set character_set_results = utf8;

set collation_connection = utf8_general_ci;

set collation_database = utf8_general_ci;

set collation_server = utf8_general_ci;

原文地址:https://www.cnblogs.com/carry-2017/p/10988212.html