##
问题背景
向MySQL插入中文内容显示问号
##
原因
Server端的MySQL不支持utf8, 部分是latin1编码格式。
mysql>show variables like "%char%";
+--------------------------------------+----------------------------+
| Variable_name | Value |
+--------------------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| validate_password_special_char_count | 1 |
+--------------------------------------+----------------------------+
9 rows in set (0.02 sec)
##
解决办法
1、直接登录MySQL改数据库, 但是MySQL重启后,修改会失效。