1 确保数据库编码设置, 可修改my.cnf
mysql> show variables like '%character%';
+--------------------------+-----------------------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+-----------------------------------------------------------+
2 确保JDBC连接串带 characterEncoding=UTF-8
jdbc:mysql:///dbname?serverTimezone=UTC&characterEncoding=UTF-8&useUnicode=true&useSSL=false&allowPublicKeyRetrieval=true
3 如果用Navicat的话还得注意, Edit Connecting ==> Encoding 默认就好.
__ __ __
这里选了UTF8,结果问题问题从Spring 配置, 对象序列化, MyBatis配置,数据库配置,终端配置一直排查到这. 汗....
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。