I cannot get emoji to work when posting from WordPress to micro.blog. I’ve disabled the standard emoji, but still no joy. Just shows ???

5 Comments

  1. smokey June 1, 2019 at 3:53 pm

    @gr36 My guess is it’s a character encoding issue somewhere (database or feed). I tried to inspect your feed, but I couldn’t find the “iOS-only podcasting setup” post (that shows “???” on the Timeline) in it.

  2. smokey June 1, 2019 at 4:16 pm

    @gr36 Yeah, it’s already “???” in the feed, which points to the database, I think (though I’m confused how it shows up properly on the blog itself). Are you inserting the emoji yourself, or using some plugin?

    Or is this an old WP install? Old versions of WP used a Latin1 MySQL db encoding, which started creating problems at some point, especially once they changed the default for new dbs and assumed all dbs were UTF-8….

    I’m away from my computer for the weekend so am of limited utility, but hopefully some of the real WP gurus here will see this.

  3. gr36 June 1, 2019 at 5:09 pm

    @smokey weirdly you wre right, I have no idea why, I’ve only been using WordPress again a few months so i dont know where the issue came from. I ran ALTER TABLE tablename CONVERT TO CHARACTER SET utf8; for each table and it seems to have worked.

    Thanks for your help

  4. smokey June 1, 2019 at 5:29 pm

    @gr36 Awesome! Glad you were able to fix it

Comments are closed.