2

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?

5
  • 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, 2014 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, 2014 at 23:05
  • What versions of mysql and linux systems are we dealing w/ here?
    – slm
    Apr 10, 2014 at 23:18
  • Both are 5.5.28. (Server version: 5.5.28-log)
    – compixtr
    Apr 11, 2014 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, 2014 at 9:26

1 Answer 1

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .