mysql > show variables like 'charcter_set_%'; 看里面的值。如果client的编码与连接代码不一致的话,就会乱码。 可以修改mysql的配置文件my.cnf,保证里面有如下两段内容,如果没有则添加进去: -------------- [client] default-character-set=utf8[mysqld] default-character-set=utf8 -------------- 修改保存之后,重启mysql服务器即可。
上面看错了,楼主把上面的utf8改成gbk即可。
[mysqld] #设定默认字符集为gbk default-character-set=gbk #设定连接mysql数据库时使用gbk,以让mysql数据库为gbk运行 init_connect='SET NAMES gbk' datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 lower_case_table_names=1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] #终端字符集,告诉Server客户端提交的SQL语句的编码格式 default-character-set=gbk mysql> show variables like 'character_set_%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | gbk | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | gbk | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) 我觉得错误在视图软件那。
看里面的值。如果client的编码与连接代码不一致的话,就会乱码。
可以修改mysql的配置文件my.cnf,保证里面有如下两段内容,如果没有则添加进去:
--------------
[client]
default-character-set=utf8[mysqld]
default-character-set=utf8
--------------
修改保存之后,重启mysql服务器即可。
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
我觉得错误在视图软件那。
+--------------------------+----------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------
-----+
| character_set_client | gb2312
|
| character_set_connection | gb2312
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | gb2312
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQ
ets\ |
+--------------------------+----------------------
-----+
8 rows in set (0.00 sec)-----------------navicat 使用mysql字符集------------