ID: 31946 Updated by: php-bugs@lists.php.net Reported By: royberkeveld at gmail dot com -Status: Feedback +Status: No Feedback Bug Type: MySQL related Operating System: Windows XP Pro PHP Version: 5.0.3 New Comment:
No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2005-02-28 21:16:28] RoyBerkeveld at gmail dot com I tested using the snapshot for Windows. Latest snapshot doesn't fix anything. I suspect it might have something to do with the mysql client libraries, they changed with the upgrade from 5.0.2 to 5.0.3 (size increase from 200kb to 1mb). I'm not sure weather this 'bug' was intended or not, since there is probably an a lot more elegant way to force mysql queries to be in a different encoding than to set the script's internal character set. I'm just stating that this method no longer works and the changelog doesn't mention anything about it. Neither do I know a better method, but that is, I believe, not of much concern to a bug report. ------------------------------------------------------------------------ [2005-02-28 20:43:01] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-02-12 15:08:52] royberkeveld at gmail dot com Description: ------------ When a script's internal character encoding is set to UTF-8, and a MySQL Query is formed, the result did not contain UTF-8 encoded data. This changed when upgrading from PHP 5.0.2 to 5.0.3 - it worked fine in 5.0.2. It does not appear MySQL-related since nothing was changed to the databases. All databases are UTF-8 encoded and the standard character set is also UTF-8. I am using MySQL 4.1.9 on Apache 2 Reproduce code: --------------- mb_http_output("UTF-8"); mb_internal_encoding("UTF-8"); // just an example, can be any query $result = mysql_query("select * from someplace"); $row = mysql_fetch_row($result); echo $row[0]; Expected result: ---------------- UTF-8 encoded data with all characters intact Actual result: -------------- Missing characters due to conversion of UTF-8 database data to Latin-1 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=31946&edit=1