涉及数据库连接、备份遇到的字符集问题
状态检查
查看数据库中字符集状态
show charset; --列出mysql支持的所有字符集
show characters set; --列出MYSQL支持的所有字符集
SHOW VARIABLES LIKE 'character_set_%'; --当前MYSQL服务器字符集设置
环境变量的关系
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/zftmysql/share/mysql/charsets/ |