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?

  • Can you not change the charset in the new server to UTF-8? The data in the DB is physically stored different based on these settings. stackoverflow.com/questions/2708958/… – slm Apr 10 '14 at 19:27
  • It's already set to utf8 for this specific database indeed. I've confirmed that database/table charsets are looking identical on both servers. – compixtr Apr 10 '14 at 23:05
  • What versions of mysql and linux systems are we dealing w/ here? – slm Apr 10 '14 at 23:18
  • Both are 5.5.28. (Server version: 5.5.28-log) – compixtr Apr 11 '14 at 0:24
  • This article is long but may help you in solving this particular issue: bluebox.net/insight/blog-article/…. I've had this problem happen to me in the past as well and I seem to recall getting the tables & DB set in UTF-8 prior, and then re-importing my mysqldumps into them once they were set appropriately. – slm Apr 11 '14 at 9:26

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.