在my.cnf分别设定默认编码
[code=BatchFile]
[mysql.server]
default-character-set=gb2312 [mysqld_safe]
default-character-set=gb2312 [client]
default-character-set=gb2312 [/code]
[code=BatchFile]
[mysql.server]
default-character-set=gb2312 [mysqld_safe]
default-character-set=gb2312 [client]
default-character-set=gb2312 [/code]
我没有cnf的配置文件。版本是5.0,windows 下的。只有一个 ini配置文件。我需要自己建一个cnf文件吗?
应该和my.ini 作用一样吧。 我配置文件里没有[mysqld_safe],我加了这一行,也不管用。关键是show variables 显示,所有的字符集变量都改过来了,但是,程序访问和控制台访问,好像不是同一个配置文件啊。
Array
(
[0] => character_set_client
[1] => latin1
)
Array
(
[0] => character_set_connection
[1] => latin1
)
Array
(
[0] => character_set_database
[1] => gb2312
)
Array
(
[0] => character_set_filesystem
[1] => binary
)
Array
(
[0] => character_set_results
[1] => latin1
)
Array
(
[0] => character_set_server
[1] => gb2312
)
Array
(
[0] => character_set_system
[1] => utf8
)