Edit report at http://bugs.php.net/bug.php?id=54421&edit=1
ID: 54421
User updated by: will dot skates at ntlworld dot com
Reported by: will dot skates at ntlworld dot com
Summary: bindValue does not process utf-8 encoded strings.
-Status: Feedback
+Status: Closed
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:
Please have my sincere apologies, this issue has been resolved. I'll
file a fix soon.
Previous Comments:
------------------------------------------------------------------------
[2011-05-10 09:28:50] u...@php.net
... and what database are you talking about. PDO works with many.
------------------------------------------------------------------------
[2011-05-10 09:28:21] u...@php.net
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".
------------------------------------------------------------------------
[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
