Edit report at http://bugs.php.net/bug.php?id=54421&edit=1
ID: 54421 Updated by: u...@php.net Reported by: will dot skates at ntlworld dot com Summary: bindValue does not process utf-8 encoded strings. -Status: Open +Status: Feedback Type: Bug Package: PDO related Operating System: Found on win and linux(centos) PHP Version: 5.3.6 Block user comment: N Private report: N New Comment: What exactly does this mean: "when set names is set as utf8 in both execute and as one of the options in the PDO construct"? Please, provide complete test script including "set names ... options in the PDO construct". Previous Comments: ------------------------------------------------------------------------ [2011-03-30 01:30:20] will dot skates at ntlworld dot com Description: ------------ I'm currently developing a piece of software system for a Russian client. When set names is set as utf8 in both execute and as one of the options in the PDO construct, no results are returned when a utf8 string is bound using bindValue(); Test script: --------------- $stmt = $pdo->prepare('SELECT * FROM table WHERE column LIKE ?'); $stmt->bindValue(1,\'%пÑивеÑ%\'); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); var_dump($result); Expected result: ---------------- array(1) { "column" => "пÑивеÑ" } Actual result: -------------- array(0){} ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=54421&edit=1