一、我们需要将默认的字符集更改为utf-8来解决数据库导入数据的乱码问题。
我们需要先查看数据库默认的字符集是什么:
show variables like 'character_set_%'
查看所有的默认字符集
mysql> show variables like 'character_set_%';
+--------------------------+---------------------------------------------------------+
| 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