+--------------------------+---------------+
| 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
评论