Duplicator & messed up special characters

  • Resolved michaelohnemus

    (@michaelohnemus)


    2 years, 11 months ago

    When exporting a webpage with duplicator all special characters are messed up in the SQL dump. Locales for mySQL and the databases are identical, same provider.

    Example

    original:
    <h2>Anfahrt</h2>
    <p>Unsere Vereinsgeb?ude befi…

    duplicator:
    <p>Unsere VereinsgebxE4ude befi…

    so character ‘?’ becomes ‘xE4’
    this results in destroyed special chars in the target.

    HOW TO RETAIN THE SPECIAL CHARS?

    Kind regards
    Michael

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter michaelohnemus

    (@michaelohnemus)

    Collation of the

    #1 source db
    is ‘latin1_german1_ci’, tables utf8mb4_unicode_520_ci, some(!) latin1_german1_ci, the example is from wp530_posts which has utf8mb4_unicode_ci, I have no idea why the collations are not unique
    #2 target db
    is ‘latin1_german1_ci’, tables all utf8mb4_unicode_520_ci

    Hey @michaelohnemus,

    If collations have different names then they might be compatible but in all cases, they are not. To be 100% sure you would need to validate on the MySQL forums. Issues C and D might have some items that help:

    – How to resolve database write issues?
    – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-103-q

    Hope that helps~

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Duplicator & messed up special characters’ is closed to new replies.