Navicat MySql中文乱码问题

navicat 数据库中文乱码问题

1.右键连接属性-->高级-->Encoding-->936(Simplified Chinese GBK)

去掉User MySql character set 选项

2.数据库安装目录

my.init 更改default-character-set=utf8

3.打开mysql client,进入后再输入show variables like "%char%";可查看更改字符集后的列表.

| character_set_client | utf8

| character_set_connection | utf8

| character_set_database | utf8

| character_set_filesystem | binary

| character_set_results | utf8

| character_set_server | utf8

| character_set_system | utf8

| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.1\share\chars

更改

set names utf8;

更改其中某一个

set @@character_set_database=utf8

set @@character_set_server=utf8

set @@character_set_results=utf8

set @@character_set_connection=utf8

set @@character_set_client=utf8

4.更改表与表字段字符编码方式

5.重启数据库