MySQL Forums :: Character Sets, Collation, Unicode :: Thai Characters display as ???


Advanced Search

Thai Characters display as ???
Posted by: Ludovic Barberet ()
Date: March 11, 2011 12:04AM

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! :)

Options: ReplyQuote


Subject Views Written By Posted
Thai Characters display as ??? 5118 Ludovic Barberet 03/11/2011 12:04AM
Re: Thai Characters display as ??? 1524 Rick James 03/12/2011 09:12AM
Re: Thai Characters display as ??? 1750 Ludovic Barberet 03/14/2011 01:36AM
Re: Thai Characters display as ??? 2232 Ludovic Barberet 03/14/2011 02:11AM
Re: Thai Characters display as ??? 1247 Rick James 03/14/2011 08:22AM
Re: Thai Characters display as ??? 1267 Ludovic Barberet 03/14/2011 08:16PM
Re: Thai Characters display as ??? 2186 Rick James 03/14/2011 09:04PM
Re: Thai Characters display as ??? 1237 Ludovic Barberet 03/14/2011 09:19PM
Re: Thai Characters display as ??? 1976 Rick James 03/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.