V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
This topic created in 4906 days ago, the information mentioned may be changed or developed.
$a = "狂神";
$sql = "select acct,login from accounts where login=:login";
$ptmt = $DB->prepare($sql);
$ptmt->bindValue(':login', $a);
$ptmt->execute();
为何$a为中文时就查不出数据，字母数字就正常
$sql = "select acct,login from accounts where login=:login";
$ptmt = $DB->prepare($sql);
$ptmt->bindValue(':login', $a);
$ptmt->execute();
为何$a为中文时就查不出数据，字母数字就正常
 |
1
bixuehujin Nov 21, 2012
难道是数据库与PHP脚本编码不匹配？
|
 |
2
wuxiaolin OP @bixuehujin 肯定一致的
|
 |
3
linlinqi Nov 21, 2012  1
创建DB对象的时候得把编码写上，例如
$DB = new PDO("mysql:dbname=dbname", "user", "password", array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'")); |
Select Language