ID: 28231 Updated by: [EMAIL PROTECTED] Reported By: alfleung at fcb dot com -Status: Feedback +Status: No Feedback Bug Type: MySQL related Operating System: windows xp PHP Version: 4.3.6 New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2004-04-30 11:04:35] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2004-04-30 09:16:10] alfleung at fcb dot com 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 this bug report at http://bugs.php.net/?id=28231&edit=1