Insertion of emoji in articles - change of database collation to utf8mb4

simpey · March 19, 2025, 9:28am

Hello,
I’m having a problem saving articles in the database when I insert an emoji in its content.
I’ve found that it’s due to some tables in my database being in ‘utf8mb3_general_ci’ instead of ‘utf8mb4’.
I read the following query:

but I can’t change the collation of my tables!
When I try to make the change in AdminerEvo, I get the following message:
‘Invalid default value for ‘post_date’ ’
How can I change the collation or/and how can I insert emojis in my articles?
Thanks for your help,
Simon

Nick-B · March 19, 2025, 3:23pm

Hi @simpey!

I found some articles here that might be helpful:

gist.github.com

https://gist.github.com/kaorukobo/718f4eb684ac01e1b65fc4cb69587fae

how-to-solve-wordpress-invalid-default-value.sql

SET SQL_MODE = '';
ALTER TABLE `wp_posts` CHANGE `post_date` `post_date` DATETIME  NOT NULL  DEFAULT '1970-01-01 00:00:00';
ALTER TABLE `wp_posts` CHANGE `post_date_gmt` `post_date_gmt` DATETIME  NOT NULL  DEFAULT '1970-01-01 00:00:00';
ALTER TABLE `wp_posts` CHANGE `post_modified` `post_modified` DATETIME  NOT NULL  DEFAULT '1970-01-01 00:00:00';
ALTER TABLE `wp_posts` CHANGE `post_modified_gmt` `post_modified_gmt` DATETIME  NOT NULL  DEFAULT '1970-01-01 00:00:00';

simpey · March 19, 2025, 4:27pm

Hi @Nick-B !
Thanks a lot! The sql commands given by your first link allowed me to change the Collation of my tables.
I can now insert emojis in my posts and save/publish them !

Nick-B · March 19, 2025, 7:49pm

Glad to hear that @simpey! Thank you for following up and sharing

system · March 21, 2025, 7:49am

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Feature Request: Change Default Database Collation to utf8mb4_unicode_520_ci (or at least utf8_general_ci) Feature requests database	1	43	August 27, 2024
Collation problem Support	4	386	December 11, 2023
Local pulls from WPEngine use a different database version breaking emojis Support	1	406	December 21, 2020
Collation mix in default setup Bugs	1	13	December 11, 2024
Migration failed - WordPress database error: [Unknown collation: 'utf8mb4_unicode_520_ci'] Support	5	3377	August 25, 2020

Insertion of emoji in articles - change of database collation to utf8mb4

Related topics