Special character's issue after migrating wordpress site

[dayakar]

I have migrated a wordpress site to another new server. The database importing was successful except that the special character's are displayed erroneously.

For eg. The string "It’s" is display as "It’s", "Montréal" as "Montréal" etc.

After googling regarding this issue, I understand that this is something related to character set encoding. So, I have set the default charset to utf8 while creating a new database in the new server. Replaced the "latin1" with "utf8" in the sql file generated by WP-DB-Backup plugin. Even after changing the charset in the sql file and importing the database didn't help in fixing the issue.

Could anybody please help me to resolve this issue.

Many thanks in advance.

--
Dayakar N

[Edwin]

Have a look at this possible solution.

[Martin]

If you can restore the database backup via phpmyadmin this problem can be fixed very easy when uploading the database.

Just delete the current database tables before the database restore then in the Import section for your database in phpmyadmin the SQL compatibility mode should be set to ANSI. The default setting is normally set to NONE.

[dayakar]

Thank you @Edwin and @Martin for the response.

@Edwin - I tried Modified UTF8-Sanitize Plugin, it only fixed some characters like "apostrophes (’)" but not the foreign characters like "é". Other solutions mentioned in the article too didn't resolve the issue.

@Martin - I am very glad to inform you that your solution has resolved the special character's issue. :-)

Can this be resolved via command line with MySql? If yes, could you please let me know about the commands.

--
Dayakar N

[Ipstenu]

It can, but if you're not hugely SQL savvy, I would suggest using this plugin:

http://wordpress.org/extend/plugins/search-and-replace/

It can search for é and replace with é, IIRC.

If you want to sql it... back up first and then try this:

UPDATE wp_posts SET post_content = REPLACE (post_content, 'é', 'é');