Discrepancy in importing UTF-8 encoded data from .sql file: any solutions ?
Posted by: Sourjya Sen
Date: June 24, 2005 08:13AM

Hi guys,
I'm facing a strange problem. My mysql db uses both latin and tis620 (Thai language) collated columns to store multilingual data. When I send in thai data through my application (.net) - mysql stores it all fine.

The problem arises, when I dump the whole table using mysqldump - the resultant text file DOES contain the mixed language data but when I try to import it back through the mysql client using "source" directive, the thai text gets transformed into the much dreaded "??????????" - any solutions to this ? Is there some other backup/import method I should follow to preserve the utf-8 text ?

Note that the problem isn't in dumping the data - but rather while importing it back the database..

Any suggestions/solution much appreciated.

Thanks & Regards,

...the average population of all the planets in the Universe can be said to be zero. From this it follows that the population of the whole Universe is also zero, and that any people you may meet from time to time are merely products of a deranged imagination.

Options: ReplyQuote

Written By
Discrepancy in importing UTF-8 encoded data from .sql file: any solutions ?
June 24, 2005 08:13AM

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.