docker 容器mysql 控制台默认不能输入中文 , 控制台插入有中文的数据是空的无效!!!
先上配置文件
[mysql]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8
[mysqld]
character_set_server = utf8
init_connect='SET NAMES utf8'
进入 bush控制台查看字符集
[root@VM-4-14-centos conf]# docker restart mysql
mysql
[root@VM-4-14-centos conf]# docker exec -it 87a33f3096fd bash
mysql -uroot -p
mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------+
| character_set_client | utf8mb3 |
| character_set_connection | utf8mb3 |
| character_set_database | utf8mb3 |
| character_set_filesystem | binary |
| character_set_results | utf8mb3 |
| character_set_server | utf8mb3 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
8 rows in set (0.01 sec)