你在mysql>show variables like "%char%"; mysql>show variables like "%coll%";能看到你的mysql字符集设置,设置都改成big5试试
如:
SET character_set_client = big5
SET character_set_connection = big5
SET character_set_database = big5
SET character_set_results = big5
SET character_set_server = big5SET collation_connection = big5
SET collation_database = big5
SET collation_server = big5
如果还不成,那你看下你已经建的数据库、数据表、字段的字符设置是什么,然后按同样方法改过来
如:
SET character_set_client = big5
SET character_set_connection = big5
SET character_set_database = big5
SET character_set_results = big5
SET character_set_server = big5SET collation_connection = big5
SET collation_database = big5
SET collation_server = big5
如果还不成,那你看下你已经建的数据库、数据表、字段的字符设置是什么,然后按同样方法改过来
...
.
.
collation_connection
character_set_results
值改成gb2312就可以了注意的地方就是有全局和会话的区别详细的用法在
http://dev.mysql.com/doc/mysql/en/SET_OPTION.html
变量名在
http://dev.mysql.com/doc/mysql/en/Dynamic_System_Variables.html
不能够看到那么多的变量包括“character_set_results”
请问:可以运行set character_set_results=big5命令吗?