#36798 [Opn->Csd]: mysql error when using named parameters in a query with high ascii

ID: 36798 Updated by: iliaa@php.net Reported By: albert at jool dot nl -Status: Open +Status: Closed Bug Type: PDO related Operating System: Debian Sarge PHP Version: 5.1.2 New Comment: This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2006-03-22 19:53:09] albert at jool dot nl Charset of the connection is default ISO-8859-1 (you need to explicitly set another charset in the dsn), and the charset of any mysql table used is default latin1 - if any solution requires changing any of these settings, consider changing PHP first :). Anyhow, notice that the query _parsing_ fails, not the query itself. The double-quote fix isn't working btw - the error just didn't show up anymore as output (which is also strange!). ------------------------------------------------------------------------ [2006-03-21 15:41:47] iliaa@php.net What is the charset of the server/connection? ------------------------------------------------------------------------ [2006-03-20 16:53:28] albert at jool dot nl oops, changed the summary ------------------------------------------------------------------------ [2006-03-20 16:52:34] albert at jool dot nl Tried the snapshot, and the problem still exists. Perhaps you aren't seeing the error because you need to explicitly set exception handling: $db = new PDO("mysql:host=$dbHost;dbname=$dbName", $dbUser, $dbPass); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); [.. and then the code ..] ------------------------------------------------------------------------ [2006-03-20 15:59:03] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip Can't reproduce. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/36798 -- Edit this bug report at http://bugs.php.net/?id=36798&edit=1