mysql load data 字符集_MySQL 字符集问题

MySQL的字符集问题可以归纳为继承问题

可以查看字符集参数例如

mysql> show variables like 'character%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | latin1客户端字符集

| character_set_connection | latin1客户与服务连接采用的字符集

| character_set_database   | utf8数据库采用的字符集

| character_set_filesystem | binary                     |

| character_set_results    | latin1SELECT查询返回数据的字符集

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)

字符集的设置可以卸载mysqld端也可以在clie