mysql5.6.14的乱码问题

mysql安装成功后用jpa框架插入数据总是乱码,查询数据库和表,发现都是utf8

在my.ini加入default_character_set=utf8,无法重新启动mysql服务.

随后发现可能是default_character_set=utf8参数不适用mysql5.6.14的版,于是在dos下进入mysql;查询show variables like 'character%';

结果如下:

+--------------------------+----------------------------------------------------
----+
| Variable_name            | Value
    |
+--------------------------+----------------------------------------------------
----+
| character_set_client     | gbk
    |
| character_set_connection | gbk
    |
| character_set_database   | latin1
    |
| character_set_filesystem | binary
    |
| character_set_results    | gbk
    |
| character_set_server     | latin1
    |
| character_set_system     | utf8
    |
| character_sets_dir       | I:\study\softtools\mysql-5.6.14-winx64\share\charse
ts\ |
+--------------------------+----------------------------------------------------
----+
8 rows in set (0.00 sec)

于是在my.ini中加入character_set_server=utf8,然后重启服务器,再输入show variables like 'character%';

| character_set_client     | gbk
    |
| character_set_connection | gbk
    |
| character_set_database   | utf8
    |
| character_set_filesystem | binary
    |
| character_set_results    | gbk
    |
| character_set_server     | utf8
    |
| character_set_system     | utf8

character_set_database也变为utf8,不知为啥.网上解释:

服务器级别 > 数据库级别 > 表级别 > 列级别

最后无乱码!!!