MySQL Bugs: #28321: Cannot show chinese stored in mysql through php web page or vise versa

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:	Windows
Assigned to:		CPU Architecture:	Any

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.

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.

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".

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

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.

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".