Docker Mysql中文问题
Docker Mysql cmd无法输入中文
docker exec -it mysql bash
mysql -uuser -ppasswd登录之后无法输入中文
#查看容器支持语言
docker exec mysql locale -a
#指定编码登录myqsl
docker exec -it mysql env LANG=C.UTF-8 /bin/bash
Mysql 无法显示中文
查询mysql无法显示中文
show variables like "%char%"
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
set character_set_client =uft8mb4;
set character_set_connection =uft8mb4;
set character_set_database=uft8mb4;
set character_set_results=uft8mb4;
set character_set_server=uft8mb4;
set ccharacter_set_system=utf8mb4;