I just moved from godaddy.com, and backed up my db to an sql file on my computer.
It happens with both ssh and web interface. Any help?
I would guess that your old database wasn't in UTF format for the foreign characters. A Google search led me to this, but I don't know if it'll help:Google Search
Is there a way to convert to UTF?
One of the results on that Google search was called Converting MySQL Database to UTF-8.
In the end it didn't help me, so I had to upload the whole DB via SQL query, one statement at a time. Took me about 20 minutes.
In addition, I had to addmysql_query("SET NAMES 'utf8'");as they suggested on wordpress forum.
I'm glad it finally worked out.
Thank you very much for your help!!!