该文章详细记录了在Hive导出数据到MySQL过程中遇到的中文乱码问题及解决方案，包括检查和修改MySQL的字符集设置，以及如何在Hive表和MySQL表之间正确转换以避免乱码。
一、mysql中的编码 mysqlgt; show variables like
一、mysql中的编码
mysql> show variables like 'collation_%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
可见原来缺省是latin1编码，会导致中文乱码。
可以在mysql中设置编码，单个设置
mysql> alter database name character set utf8;
mys
最低0.47元/天 解锁文章
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
