java 保存到 mysql 乱码

java中正常， 保存到mysql后乱码

 

先查看：

show variables like 'character%'; 

 

 结果：

'character_set_client','utf8'

'character_set_connection','utf8'

'character_set_database','utf8'

'character_set_filesystem','binary'

'character_set_results','utf8'

'character_set_server','latin1'

'character_set_system','utf8'

'character_sets_dir','/usr/local/mysql-5.6.16-osx10.7-x86_64/share/charsets/'

 

找到mysql配置文件

添加 character_set_server=utf8.

 

重启mysql， 解决