Elena Rossini ⁂
@pfefferle Matthias! I'm incredibly grateful for all your amazing advice and quick help 🙏 ✨ 🏆
I have a question which is NOT URGENT AT ALL, just something I'm curious about. And sorry to bug you about this, but it's something I can't find an answer to on my own.
Comments coming in from the Fediverse can sometimes have emojis - that do not render at all on my Wordpress blog, they show up as question marks. Is there anything I can do to add emoji support so the comments will display correctly?
Matthias Pfefferle
@_elena thanks a lot 😊
do you have an example for a broken emoji, so that I can have a look?
Elena Rossini ⁂
@pfefferle Thank you Matthias!!!
Your comment for example, on yesterday's post (see screenshots)
Matthias Pfefferle
@_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/
Elena Rossini ⁂
@pfefferle thank you Matthias! I understand... I'll try see if I can get help from my webhost about this (because I wouldn't even know where to start) 😅😆
Matthias Pfefferle
@_elena 🤞
Elena Rossini ⁂
@pfefferle I just got a super fast reply with a clear step-by-step guide from their AI support bot. The only use of AI I approve of, LOL 😂
Matthias Pfefferle
@_elena I hope the AI is right on that! 😳
😂
Elena Rossini ⁂
@pfefferle PhpMyAdmin didn't help, so I'm about to manually change my wp-config.php file and see how things go.
Mind you Matthias I'm an artist, NOT a developer. About to take a big sip from my cup of coffee, pray and hope I don't break my site LOL (I do have access to file manager and I have a backup of the old file ready to be re-uploaded just in case). Living on the edge 😅
Elena Rossini ⁂
@pfefferle P.S.: you'd appreciate that the AI support bot is very careful and keeps reminding me "Make sure to back up the file before making any changes." 😅
Matthias Pfefferle
@_elena OMG 😱
good luck!
btw. this haven't worked out?
be aware that the change might not fix actual comments, but future ones!
Elena Rossini ⁂
@pfefferle ha! Thank you re: the clarification that it may not fix existing comments but future ones... I kept deleting the cache and checking from a browser in incognito mode, but nothing helped. This makes perfect sense. I'll publish a brand new comment from here and see how things go. THANK YOU AGAIN!
Matthias Pfefferle
@_elena 🎉 🙌
☺️
Elena Rossini ⁂
@pfefferle it finally worked and I didn't break anything - woohoo!!! 🥳 thank you again Matthias!!!! 🏆
Aslak Raanes
@_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
Matthias Pfefferle
@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.
Aslak Raanes
@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?
Matthias Pfefferle
@aslakr @_elena I thought it was needed but doesn't seem so.
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.