Problem with special characters when migrating

  • Hello everyone,

    Situation :

    I installed a wordpress locally with Mamp, installed a theme (Pure from GT3) and then filled a Portfolio with articles.
    Everything was right, then I transferred it to an OVH server.

    But now, every special character (french) I had in my posts or img url are not displayed correctly

    Screen of some text : https://img15.hostingpics.net/pics/988083Sanstitre.png
    It’s very weird because in the database when I check the post_content I have something like :

    Création de goodies pour Do It in Paris comme les cartes postales pour promouvoir la marque. Mais aussi du?Calendrier 2015 pour les clients de Do It in Paris.

    So nothing seems wrong.

    I checked everything, the database and tables are in utf8mb4_unicode_ci, the wp-config contains : 

    define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', '');

    So here again, encoding seems fine

    And I saw that when I update a post inside the back-office of WordPress, the post_content changes and some weird characters appear in the database :

    Cr??ation de goodies pour Do It in Paris comme les cartes postales pour promouvoir la marque. Mais aussi du??Calendrier 2015 pour les clients de Do It in Paris.

    But then text is displayed correctly on front-office.

    Screen : https://img15.hostingpics.net/pics/638455Sanstitre.png

    Is it possible to fix this issue without having to enter every picture and text again in the back-office ?
    I saw that at first in mamp, the database was in latin_swedish encoding, but every table was in utf-8 as above. I tried to change the database on Mamp to utf-8 but the exported sql file is exactly the same as before and no mention of latin inside the sql file.

    I hope someone can help … Thank you

    Templar

    PS : You can see the website here : https://www.manonmoisy.com/

    [ No bumping please. ]

Viewing 3 replies - 1 through 3 (of 3 total)
  • nfu

    (@ivannrobert)

    Hello!
    I’m facing the same character issue after migrating from local to server (same host as you OVH). And I saw it’s corrected on your website.
    Do you find any method to resolve this?

    Many thanks

    Hi guys,

    I’ve got exactly the same problem, did you manage to solve it?

    Many thanks

    OK after a few hours of research I’ve used the WP Migrate DB plugin:

    I’ve removed the two default Find and Replace rules and unchecked Replace GUIDs in advanced options.

    After the conversion you will get a sql file with the converted data and structure so that tables that were on utf8mb4 are now utf8 (of course you have to import that file into the database – DO NOT FORGET TO DO A BACKUP OF THE EXISTING DATABASE FIRST).

    You also have to change the setting in the wp-config.php file to define(‘DB_CHARSET’, ‘utf8’);

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Problem with special characters when migrating’ is closed to new replies.