Bug #18375 Updated: charset support for embedded libmysql

ID: 18375 Updated by: georg@php.net -Summary: more mysql module info in phpinfo(); Reported By: Xuefer@21cn.com Status: Assigned Bug Type: MySQL related Operating System: all PHP Version: 4.2.0 Assigned To: zak New Comment: Sorry, unfortunately I changed the summary few days before Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2002-07-17 01:53:06] sniper@php.net Everyplace where php_addslashes is used, it's only used if the magic_quotes_* stuff is turned on (magic_quotes_runtime)..or is there someplace where it is used anyway? ------------------------------------------------------------------------ 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