Thai Characters display as ???
Hello,
We wanted to upgrade our web server and in the same time we also upgraded the MySQL server from version 4.1 to the latest version (5.5.9).
We kept the MYD, MYI and FRM files but forget to do a .sql file backup.
After installing the new version of the server, we copied the raw MySQL file into the MYSQLserver/data folder and it seems to be OK for the other databases but the one with the thai characters in it is now showing weird characters in PHPMyAdmin, for example: "Ê»Ê.ÂéÓ¼Ùé»ÃСѹµ¹ÇèÒ§§Ò¹ÃÕº¢Öé¹·ÐàºÕ¹ÀÒÂã¹ 30 ÇÑ" instead of thai characters. The collation of the tables is now latin1_swedish_ci. When I put the table collation to tis_thai_ci, the weid characters become: "??????".
And in the website, the thai text is only showing ??? whatever collation. You can have a look at www.mctric.com/news.php for an example.
I set up a new MySQL server and try to import data into it, export it but nothing changed. Any ideas to convert the raw files to .sql query file or solve this issue in another way?
Any help would be greatly appreciated! :)
Subject
Views
Written By
Posted
Thai Characters display as ???
8811
March 11, 2011 12:04AM
2627
March 12, 2011 09:12AM
2503
March 14, 2011 01:36AM
2904
March 14, 2011 02:11AM
1823
March 14, 2011 08:22AM
1984
March 14, 2011 08:16PM
2946
March 14, 2011 09:04PM
1975
March 14, 2011 09:19PM
3038
March 14, 2011 11:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.