Discrepancy in importing UTF-8 encoded data from .sql file: any solutions ?

[Sourjya Sen]

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,
Sourjyo

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