[wp-trac] [WordPress Trac] #59868: Database insert with emoji fails when table has columns with both utf8mb3 (utf8) and utf8mb4 charsets

[WordPress Trac]

#59868: Database insert with emoji fails when table has columns with both utf8mb3
(utf8) and utf8mb4 charsets
--------------------------------------+-----------------------------
 Reporter:  ianmjones                 |       Owner:  (none)
     Type:  defect (bug)              |      Status:  new
 Priority:  normal                    |   Milestone:  Future Release
Component:  Charset                   |     Version:  4.2
 Severity:  normal                    |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:
--------------------------------------+-----------------------------

Comment (by jondaley):

 My fix is still required to get emojis to get inserted into the database
 properly.  I'm not sure how to debug this further - I assume it is working
 for other people.

 Maybe converting my database manually, which fixed it before the code was
 updated, is now making it break again?

 My charset is not simply utf8, so the exact check is failing and the
 strpos is required.

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