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?
MySQL Database Charset
mysql
I was able to fix the issue by replacing all special characters - those do not show up properly - with their original ones. (Thanks to interconnect/it's Search & Replace Tool) The important thing to pay attention at that point was to replace the charset of all these replaced items with utf8 as well. I was missing that part and when the items were replaced, they still were not showing up properly since the correct charset was not set.