Problems Migrating Emoji’s which are stored in the Database

  • Resolved Tom

    (@esilverstrike)


    5 months, 2 weeks ago

    FYI I have migrated several websites and have found that emojis do not migrate over. They end up showing as a bunch of question marks.

    This is happening in both Gutenberg content (ie blog posts) and Bricks Builder content.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support amanbv

    (@amanbv)

    Hey Tom,

    Thank you for reaching out to us.

    Emojis turn into question marks because the charset on the new website would be different compared to the older site. Your new hosting provider would be able to check what the charset was on the older server compared to what it is now. They can also help you change the charset to resolve the mismatch issue.

    Thank you!

    Thread Starter Tom

    (@esilverstrike)

    Hi,

    Thanks for the reply. That was my first thought as well. My new server DB uses:

    utf8mb4_general_ci

    and the original Cloudways DB used:

    utf8mb4_unicode_520_ci

    I thought that if it fell under utf8mb4… the emojis should have been okay?

    @amanbv I’m migrating a website within the same hosting (the db is the same) and it adds question marks to most of the emoji. On the site I use: utf8_unicode_ci. What should I use to make this work?

    Thread Starter Tom

    (@esilverstrike)

    I think the same thing happened to me… I’ll have to double check this to be sure…

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.