[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 you will want to figure out how to convert your database into
 `utf8mb4`. it's possible, though unlikely, that in the past those were
 being stored as their HTML numeric character references. For example,
 `U+1F604` can be saved in HTML using only basic ASCII characters as
 `😄` or as `😄`.

 Another possibility which is more likely is that there were some glyphs
 that were saving because they only require three bytes, as `⚄` did.
 Another example is the ❤️, which only requires three bytes in utf8.

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