[wp-trac] [WordPress Trac] #60362: Emojis cause "Updating failed. Could not update post in the database." error

[WordPress Trac]

#60362: Emojis cause "Updating failed. Could not update post in the database."
error
--------------------------+------------------------------
 Reporter:  mikefitzman   |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by dmsnell):

 @mikefitzman can you check on which encoding your database is using? if
 it's storing content with the `utf8mb3` encoding then it cannot represent
 characters which require four bytes in utf8.

 you can test this out indirectly by saving a post separately with each of
 the following two characters:
  - `😄` (U+1F604) requires four bytes to encode in utf8, this should fail
 if the database encoding is `utf8mb3`
  - `⚄` (U+2684) requires only three bytes to encode in utf8, a post should
 save with this character in it.

 ideally, for many reasons, it would be preferable to store your database
 content as `utf8mb4`.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/60362#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform