1. 将excel表格转换成csv格式
将excel表格以csv格式导出,在导出时格式选择CSV UTF-8(逗号分隔)*.csv:
图1.1:以CSV UTF-8的格式导出excel表格
2. 配置mysql数据库编码
我们要把utf8编码格式的文件导入到mysql中,因此需要设置mysql字符集为utf8。
进入mysql,查看mysql当前字符集:
> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |