I have just migrated a MySQL database to a new server using mysqldump. The charset of database is normally UTF-8 and everything was working fine on the old server but when we switched over to new one, the special characters started not to show properly. The only difference I can see between two servers is that the default charset of new server is set to latin1 in my.cnf whereas this was not the case on old server.
I have tried to replace all these special characters using interconnect/it's tool but that did not work.
What needs to be done to get this fixed? What should one pay attention to in such a situation? Charsets of database, table?