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: [image] Feature Request: Change Default Databa…

Hi @simpey ! I found some articles here that might be helpful: 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-…

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 ! :+1: :clap: :wink:

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

WordPress Questions

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

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

Topic		Replies	Views
Feature Request: Change Default Database Collation to utf8mb4_unicode_520_ci (or at least utf8_general_ci) Feature requests database	1	98	August 27, 2024
Local pulls from WPEngine use a different database version breaking emojis Support	0	430	September 22, 2020
Migration failed - WordPress database error: [Unknown collation: 'utf8mb4_unicode_520_ci'] Support	4	3422	February 19, 2017
Collation problem Support	3	448	September 12, 2023
Set or Change default Collation Support	0	463	May 22, 2020

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

Related topics