java向mySql插入数据乱码

Question

为什么我执行以下命令行后暂时成功改成了utf8，但是退出mysql后重新进入又变成gbk编码了呢
mysql> SET character_set_client = utf8;

mysql> SET character_set_results = utf8;

mysql> SET character_set_connection = utf8;

Answer 1

你要在my.ini需要修改两处
default-character-set=utf8
character-set-server=utf8
而且修改后还需要重启mysql的服务