Bug #28321 Cannot show chinese stored in mysql through php web page or vise versa
Submitted: 9 May 2007 2:50 Modified: 22 May 2008 12:47
Reporter: Elsa Leung Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Charsets Severity:S1 (Critical)
Version: OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[9 May 2007 2:50] Elsa Leung
Description:
Dear sirs/madams,

I am writing a program with php and mysql in Window XP. I need to show both English and Tranditional Chinese at the same time same page. I set everything in utf8-unicode-ci. For the web pages, they show english and chinese at the same page same time without problem. But if the Chinese is store in the database/table, when the web pages call the data stored in the table, the chinese showed up as "monster charaters".

In the above case, the chinese written inside the database/table are through PhpMyadmin.

However if I written the chinese into the database/table through the inter-active web pages, the chinese can be showed without problem. But if then I go into the corresponding table and check the chinese store inside through this method, the chinese again is showed up in "monster charaters"

The php, apache and mysql is a package I downloaded from www.xampp.org in a zip file format, and exacted into c:\xampp\.

zip file name is xampp-win32-1.6.1.zip

thanks,

How to repeat:
always there.
[10 May 2007 7:58] Sveta Smirnova
Thank you for the report.

Please provide repeatable test case to we can repeat described problem. We need: output of SHOW CREATE TABLE problem_table statement and small PHP script shows the  problem. Also be sure web server encoding settings are correct. We can not consider this is MySQL bug until we get this information.
[10 Jun 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, 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".
[15 Apr 2008 7:59] pedro victor
i have the same proble,the example is in:
http://147.83.15.184/ws/mio88/prueba2.php
in it i'm showing zhongwen in piyin and in chinese characters
[22 Apr 2008 12:47] Sveta Smirnova
Pedro,

thank you for the feedback. But we still need answer on my questions from earlier comment to be able repeat the problem on our side.
[22 May 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, 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".