ID: 18375
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Assigned
+Status: Bogus
Bug Type: MySQL related
Operating System: all
PHP Version: 4.2.0
Assigned To: zak
New Comment:
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.
Thank you for your interest in PHP.
Duplicate, see #15375 (missing charset support in embedded libmysql).
Georg
Previous Comments:
------------------------------------------------------------------------
[2002-07-26 15:36:30] [EMAIL PROTECTED]
Sorry, unfortunately I changed the summary few days before
------------------------------------------------------------------------
[2002-07-20 15:32:53] [EMAIL PROTECTED]
Ok, looks like we have to do something with the embedded libmysql
charset support.
Assigned to Zak :)
------------------------------------------------------------------------
[2002-07-20 07:44:42] [EMAIL PROTECTED]
i've tested with lastest build
but sorry to tell u that, problem still there
<?php
$data = chr(160) . "'";
echo mysql_character_set_name();
$data = mysql_real_escape_string($data);
mysql_query("SELECT '$data'"); // got error
?>
win32 build and bundled libmysql still has no gbk support build-in
gbk and other multibyte charset has to be built in (i don't bother why
have to)
get the same error
MySQL - 1064 - You have an error in your SQL syntax near '' \''' at
line 1
and i have to put gbk.conf in shared/charset dir in order to `fake' a
charset which has to be built-in, although it's not right, but it's my
only way
mysql_character_set_name() return gbk
if didn't put gbk.conf, return latin1, and apache/logs/error.log
complain about missing charset file
------------------------------------------------------------------------
[2002-07-20 03:49:07] [EMAIL PROTECTED]
To escape data please use mysql_real_escape_string
function, which is implemented in the current cvs version.
http://www.php.net/manual/en/function.mysql-real-escape-string.php.
------------------------------------------------------------------------
[2002-07-17 02:48:51] [EMAIL PROTECTED]
tested with latest build
still can't pass
also checkout cvs source
it's not libmysql 4
------------------------------------------------------------------------
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/18375
--
Edit this bug report at http://bugs.php.net/?id=18375&edit=1
