Docker Mysql中文问题

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;