Bug #51477 [Opn]: bind chinese Param to prepare statment return null

Edit report at http://bugs.php.net/bug.php?id=51477&edit=1 ID: 51477 User updated by: cage dot liu at gmail dot com Reported by: cage dot liu at gmail dot com Summary: bind chinese Param to prepare statment return null Status: Open Type: Bug Package: PDO related Operating System: windows2003 PHP Version: 5.2.13 New Comment: Test Script works fine but when the ? more than one in the sql : select gh,xm from teachers where gh=? or xmpy like ? or upper(xmpinyin) like ? or xm like ? order by xmpy chinese works but other filed failed select gh,xm from teachers where xmpy like ? or upper(xmpinyin) like ? or xm like ? or gh=? order by xmpy other filed search works but xm failed only xm filed include chinese Previous Comments: ------------------------------------------------------------------------ [2010-04-05 13:46:59] cage dot liu at gmail dot com please turn off ------------------------------------------------------------------------ [2010-04-05 13:28:48] cage dot liu at gmail dot com Description: ------------ when use prepare statment ,binding chinese string to ? or var return empty result . Test script: --------------- $ora = new pdo("oci:dbname=//host:1521/racl;charset=zhs16gbk",$urp_user,$urp_pass,array(PDO::ATTR_PERSISTENT => false)); $sql = "select gh,xm from t where xm like ? order by xmpy"; $stmt = $ora ->prepare($sql); $stmt->bindParam(1,strtoupper($_GET['xmpy'].'%'); $stmt->execute(); $r = $stmt->fetchAll(PDO::FETCH_ASSOC); //$r = $ora->query_all("select gh,xm from t where xm like '".iconv('utf-8','gbk',$_GET['xmpy'])."%'"); file charset is utf-8.the build-in sql works fine ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=51477&edit=1