这是MySQL的问题,不属于SQL Server版for example:
---------------------------------------------
1. 修改/etc/my.cnf文件.改成如下内容:[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8[mysql.server]
user=mysql
basedir=/var/lib[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid注意.就是加入了一句: default-character-set=utf82. 命令 /etc/init.d/mysqld restart 重新启动MySQL.3. 打开PhpMyadmin. 选择Lang为"Chines simplifies(zh-utf-8)". 选择"MySQL连接校对为utf8_general_ci". 点"服务器变量和设置". 可以看到:character set client utf8 utf8
character set connection utf8 utf8
character set database utf8 utf8
character set results utf8 utf8
character set server utf8 utf8
character set system utf8 utf8
collation connection utf8_general_ci utf8_general_ci
collation database utf8_general_ci utf8_general_ci
collation server utf8_general_ci utf8_general_ci从这里可以看到character全部变成UTF-8了.
---------------------------------------------
1. 修改/etc/my.cnf文件.改成如下内容:[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8[mysql.server]
user=mysql
basedir=/var/lib[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid注意.就是加入了一句: default-character-set=utf82. 命令 /etc/init.d/mysqld restart 重新启动MySQL.3. 打开PhpMyadmin. 选择Lang为"Chines simplifies(zh-utf-8)". 选择"MySQL连接校对为utf8_general_ci". 点"服务器变量和设置". 可以看到:character set client utf8 utf8
character set connection utf8 utf8
character set database utf8 utf8
character set results utf8 utf8
character set server utf8 utf8
character set system utf8 utf8
collation connection utf8_general_ci utf8_general_ci
collation database utf8_general_ci utf8_general_ci
collation server utf8_general_ci utf8_general_ci从这里可以看到character全部变成UTF-8了.
还是工具修改,什么工具?
我用的EMS
选择数据库,右健点击“database registration info...”,进入database registration info对话框,选择connection选项,设置“client charset”为“latin1 (ISO 8859-1 West European)”就可以了
不知道是不是lz所要得