count()语句不对的疑惑

浏览:4611 发布日期:2014/05/16 分类:求助交流
下面的语句或者查询条件为非中文的可以查询到数量值:
SELECT COUNT(id) AS tp_count FROM `equipfault` WHERE ( `equipTypeId` = 1 ) AND ( `orgId` = '12' ) ORDER BY id desc LIMIT 1
而下面的添加中文条件却反馈数量为0, 语句执行没问题是3:
SELECT COUNT(id) AS tp_count FROM `equipfault` WHERE ( `equipTypeId` = 1 ) AND ( `repairPerson` LIKE '%孙%' ) AND ( `orgId` = '12' ) ORDER BY id desc LIMIT 1




测试发现($_GET['repairPerson']获取之后直接用返回3,转成汉字语句返回0)
SELECT COUNT(id) AS tp_count FROM `equipfault` WHERE ( `equipTypeId` = 1 ) AND ( `repairPerson` LIKE '%瀛�%' ) AND ( `orgId` = '12' ) LIMIT 1
'%瀛�% 就是 转成汉字的 '%孙%
最佳答案
评论( 相关
后面还有条评论,点击查看>>