1)查看数据库编码的方法
MariaDB [itat_hibernate]> show variables like "%character%"
+--------------------------+----------------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------------+
| 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_sets_dir | C:\Program Files\MariaDB 5.5\share\charsets\ |
+--------------------------+----------------------------------------------+
2)设置character_set_client,character_set_connection,character_set_results的方法
使用set names gbk;或者set names utf8;
在命令行中看时注意DOS的默认当前编码,如果数据库是utf8有可能会因为DOS的默认编码是936
3)设置character_set_database,character_set_server为utf8的方法
找到C:\Program Files\MariaDB 5.5\data\my.ini
[mysqld]下增加character-set-server=utf8
[client]下增加default-character-set=utf8
[mysql] 下增加default-character-set=utf8
4)使用net stop mysql,net start mysql 重启服务