Conversation

Notices

1. Embed this notice
   Aslak Raanes (aslakr@mastodon.social)'s status on Tuesday, 01-Oct-2024 21:49:15 JST Aslak Raanes

   • Matthias Pfefferle
   • Elena Rossini ⁂

   @_elena @pfefferle But does a new installation of WordPress still default to utf8 https://developer.wordpress.org/apis/wp-config-php/#database-character-set ? Using wp-cli seems to do that https://developer.wordpress.org/cli/commands/config/create/#:~:text=database%20charset.%0A%E2%80%94-,default%3A%20utf8,-%E2%80%94

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 18:58:24 JST Matthias Pfefferle

     • Elena Rossini ⁂

     @_elena thanks a lot 😊

     do you have an example for a broken emoji, so that I can have a look?

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 19:22:53 JST Matthias Pfefferle

     • Elena Rossini ⁂

     @_elena I made a test post using your comment form with the same issue, so this is not an ActivityPub only issue.

     Maybe your DB is not setup properly?!?

     You have to use `utf8mb4` as charset and `utf8mb4_unicode_ci` as collation.

     https://make.wordpress.org/core/2015/04/02/omg-emoji-%F0%9F%98%8E/

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 19:26:53 JST Matthias Pfefferle

     • Elena Rossini ⁂

     @_elena 🤞

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 19:45:20 JST Matthias Pfefferle

     • Elena Rossini ⁂

     @_elena I hope the AI is right on that! 😳

     😂

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 19:57:27 JST Matthias Pfefferle

     • Elena Rossini ⁂

     @_elena OMG 😱

     good luck!

     btw. this haven't worked out?

     be aware that the change might not fix actual comments, but future ones!

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 20:15:26 JST Matthias Pfefferle

     • Elena Rossini ⁂

     @_elena 🎉 🙌

     ☺️

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 21:49:15 JST Matthias Pfefferle

     in reply to

     • Elena Rossini ⁂

     @aslakr @_elena I think this is only a problem of long existing installations, where the migration might not have worked properly.

     my test systems all have set it properly.

   • Embed this notice
     Aslak Raanes (aslakr@mastodon.social)'s status on Tuesday, 01-Oct-2024 22:50:13 JST Aslak Raanes

     in reply to

     • Matthias Pfefferle
     • Elena Rossini ⁂

     @pfefferle @_elena Hm, the following:

     wp core download
     wp config create …
     wp core install …

     creates a config with

     DB_CHARSET='utf8'

     but with database tables having `utf8mb4_unicode_520_ci`

     Shouldn’t the DB_CHARSET be utf8mb4 or doesn’t it matter?

   • Embed this notice
     Matthias Pfefferle (pfefferle@mastodon.social)'s status on Tuesday, 01-Oct-2024 22:51:01 JST Matthias Pfefferle

     in reply to

     • Elena Rossini ⁂

     @aslakr @_elena I thought it was needed but doesn't seem so.