ID: 36798
User updated by: albert at jool dot nl
Reported By: albert at jool dot nl
-Status: Feedback
+Status: Open
Bug Type: PDO related
Operating System: Debian Sarge
PHP Version: 5.1.2
New Comment:
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!).
Previous Comments:
------------------------------------------------------------------------
[2006-03-21 15:41:47] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[2006-03-20 15:54:34] albert at jool dot nl
Changing the single quotes in the query to double seems to fix the
problem.
------------------------------------------------------------------------
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
