mysql打开数据库中文乱码_MySql数据库中文乱码解决方法

+--------------------------+---------------+

| Variable_name | Value |

+--------------------------+---------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

+--------------------------+---------------+

1、修改数据库默认字符集：

打开C:\Program Files\MySQL\MySQL Server 5.0里面的my.ini文件找到这段文字：

引用

# The default character set that will be used when a new schema or table is

# created and no character set is defined

default-character-set=latin1

把default-character-set=latin1改为default-character-set=gbk

这时候show 一下字符集(重新启动mysql服务 ，命令：show variables like"%char%"; )显示如下：

+--------------------------+---------------+

| Variable_name | Value |

+--------------------------+---------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | gbk |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

+--------------------------+---------------+

2、如果你是导入的数据库，需要对my.ini做如下修改找到

引用

[client]

port=3306

[mysql]

default-character-set=latin1

把 default-character-set=latin1改为default-character-set=gbk

引用

# SERVER SECTION

# ----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server. Make sure that

# you have installed the server correctly (see above) so it reads this

# file.

#

[mysqld]

找到

增加default-character-set=gbk

然后在设置一下你导入的数据库字符集即可：

命令:alter database  你的数据库名 charset = gbk;

重新启动mysql服务,show 一下字符集(，命令：show variables like"%char%"; )显示如下：

+--------------------------+---------------+

| 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 |

+--------------------------+---------------+

如果你见到如上内容，数据库字符集问题已解决。

如果你的项目还有字符集问题，那就需要查看一下是否是其他因素导致的乱码了，比如我开篇时提到的问题。

分享到：

2008-11-21 15:01

浏览 8100

评论