[quote]What version of MySQL is on that other host you dump database from?
[quote]Are imported data readable in mysqladmin?
[quote]Are data readable in your web application (cms, forum, blog or whatever)?
[quote]You probably experiencing troubles with moving from mysql ver 4.0 to ver 4.1. If that is case you have to convert all varchar/text fields to utf-8, and to avoid charset conversion (your data are probably already in utf8 even if charset was set to latin1), you have to convert it to blob first, and afterwards to their original type, but now with utf8 encoding.
It seems that I’m NOT moving from ver 4.0 to v4.1, right?
[quote]There is another issue with php, mysql 4.1 and utf8. After connecting to database from your web application, you must execute query “SET NAMES utf-8” if you want to retrieve correct data from db, otherwise some charset conversion will occur and you will get garbage on your pages.
I’m using rails.
Any other possibility? Thanks a lot if you think of any.