今天研发反馈导入的数据乱码，我心想：这不是你们给我的数据吗？？不过话不多说先解决问题：
1、首先查看数据库目前的编码情况：
show variables like 'character_set_%'
mysql> show variables like 'character%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec)
2、临时修改：
mysql> set character_set_database='utf8'
-> ;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> set character_set_server='utf8';
Query OK, 0 rows affected (0.00 sec)
3、再次查看，研发反馈没有乱码了
mysql> show variables like 'character%'; +--------------------------+----------------------------+ | 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 | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec)
因为我是docker环境 永久修改的话还不知道如何改，后续更新。。。。。。。。
看看这个文章 https://www.jb51.net/article/200229.htm