[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:  needs-patch needs-unit-tests  |     Focuses:
------------------------------------------+-----------------------------
Changes (by jorbin):

 * version:  trunk => 4.2
 * milestone:  Awaiting Review => Future Release


Comment:

 I think the first step for this is an automated test to demonstrate the
 issue. This might only affect specific versions of MySQL or MariaDB, so it
 would be good to know if this is an all version bug or a specific version
 one. Once there is a test and it's known, I think this can get moved into
 a milestone. Depending on the scope of the fix, it may also need the
 `early` tag but I think it's too early for that decision.

 Updating the version to 4.2 since that is when utf8mb support was added
 and from the description, it sounds like something that has been around
 since then.

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