mysql查询不出结果
本地模糊查询没有问题,但是,上传到服务器上面 !一个搜索的功能就不能使用了!一直找不出什么原因,郁闷啊。哪位高人帮帮我啊!我本地字符集
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也查询不出!,本人在线等。谢谢大家帮我解决下啊