#18375 [Asn->Bgs]: charset support for embedded libmysql

ID: 18375 Updated by: georg@php.net Reported By: Xuefer@21cn.com -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] georg@php.net Sorry, unfortunately I changed the summary few days before ------------------------------------------------------------------------ [2002-07-20 15:32:53] georg@php.net Ok, looks like we have to do something with the embedded libmysql charset support. Assigned to Zak :) ------------------------------------------------------------------------ [2002-07-20 07:44:42] Xuefer@21cn.com 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] georg@php.net 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] Xuefer@21cn.com 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