来源:https://blog.csdn.net/weixin_42194215/article/details/111265687
1. 查看系统支持的编码
show variables like 'character%';
2. 查询时设置 session 的编码
set names utf8; select * from logs;
set names utf8
等价于:
- SET character_set_client = utf8;
//表示SQL离开客户端时的编码
- SET character_set_results = utf8;
//服务器返回的结果集编码
- SET character_set_connection = utf8;
//服务器接收后转换的字符编码