From: alfleung at fcb dot com Operating system: windows xp PHP version: 4.3.6 PHP Bug Type: MySQL related Bug description: Problem with retrieval and display of Chinese characters encoded in utf8
Description: ------------ Apache version: 1.3.7 Mysql 5.0.RC2 PHPmyadmin 2.6.0 PHP - have tried with 4.3.3, 4.3.6 and 5.0.0 with same results Mysql database tables are all charset utf8. 90% of data is English, with a handful of columns in Chinese, but all with charset utf8. Loaded data created with Notepad with utf-8 encoding as tab delimited text files with no problem. The Chinese characters were displayed correctly when viewed with PHPmyadmin 2.6.0 version but not earlier releases. However, when the data is fetched by a PHP script using the database variables with no other manipulations on the variables, the Chinese characters show up as ? for each character. The Meta tags and header function were set. IE shows utf-8 encoding. I would appreciate very much if you could determine what the problem is :-) I have also tested with coding Chinese characters in the PHP script ( which then have to be saved with utf8 encoding), the display of the hard-coded in Chinese characters is okay, but not the variables fetched from the Mysql database!! Reproduce code: --------------- It's a rather large series of files and I don't have a static IP address for the URL right now. But I still hope that you would look into this if you receive other reports similar to mine. Thanks for reading this. Alfred -- Edit bug report at http://bugs.php.net/?id=28231&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28231&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28231&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=28231&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=28231&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=28231&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=28231&r=needscript Try newer version: http://bugs.php.net/fix.php?id=28231&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=28231&r=support Expected behavior: http://bugs.php.net/fix.php?id=28231&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=28231&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=28231&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=28231&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28231&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=28231&r=dst IIS Stability: http://bugs.php.net/fix.php?id=28231&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=28231&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=28231&r=float
