本地模糊查询没有问题,但是,上传到服务器上面 !一个搜索的功能就不能使用了!一直找不出什么原因,郁闷啊。哪位高人帮帮我啊!我本地字符集
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir d:\wamp\bin\mysql\mysql5.0.51b\share\charsets\服务器上面的Variable_name Value
character_set_client latin1
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/ 到底是什么原因啊 查询的sql语句是
select * from zhaop where 1=1 and zpd like '%武汉%' order by zpp asc, id desc连接数据库的时候已经指明 mysql_query("set names utf8");
但是最后还是查询不出来,直接用phpmyAdmin执行sql也查询不出!,本人在线等。谢谢大家帮我解决下啊
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir d:\wamp\bin\mysql\mysql5.0.51b\share\charsets\服务器上面的Variable_name Value
character_set_client latin1
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/ 到底是什么原因啊 查询的sql语句是
select * from zhaop where 1=1 and zpd like '%武汉%' order by zpp asc, id desc连接数据库的时候已经指明 mysql_query("set names utf8");
但是最后还是查询不出来,直接用phpmyAdmin执行sql也查询不出!,本人在线等。谢谢大家帮我解决下啊
连接数据库的时候已经指明 mysql_query("set names utf8");但是最后还是查询不出来,直接用phpmyAdmin执行sql也查询不出!"你数据库有这样的记录么!
改成
mysql_query("set names gbk");
或者
mysql_query("set names gb2312");试一下