my.ini中加上
[mysqld]
default-character-set= gbk
default-collation=gbk_chinese_ci[client]
default-character-set= gbk_chinese_ci程序中运行sql语句前,设置字符集
SET character_set_client = gbk
SET character_set_connection = gbk
SET character_set_database = gbk
SET character_set_results = gbk
SET character_set_server = gbk
SET collation_connection = gbk_chinese_ci
SET collation_database = gbk_chinese_ci
SET collation_server = gbk_chinese_ci如果还有??存在,把每一个GBK编码的sql语句转成ISO_8859_1
为什么就不明白了,我这个样子能正常操作
[mysqld]
default-character-set= gbk
default-collation=gbk_chinese_ci[client]
default-character-set= gbk_chinese_ci程序中运行sql语句前,设置字符集
SET character_set_client = gbk
SET character_set_connection = gbk
SET character_set_database = gbk
SET character_set_results = gbk
SET character_set_server = gbk
SET collation_connection = gbk_chinese_ci
SET collation_database = gbk_chinese_ci
SET collation_server = gbk_chinese_ci如果还有??存在,把每一个GBK编码的sql语句转成ISO_8859_1
为什么就不明白了,我这个样子能正常操作
default-character-set= gbk2312
然后重启服务
试试!记不清了