[wp-trac] [WordPress Trac] #31328: Emoji in a slug fails to display

[WordPress Trac]

#31328: Emoji in a slug fails to display
----------------------------------------+-----------------------------
 Reporter:  kraftbj                     |       Owner:
     Type:  defect (bug)                |      Status:  new
 Priority:  normal                      |   Milestone:  4.2
Component:  Formatting                  |     Version:  trunk
 Severity:  normal                      |  Resolution:
 Keywords:  has-patch needs-unit-tests  |     Focuses:  administration
----------------------------------------+-----------------------------

Comment (by pento):

 [attachment:31328.2.diff] adds support for post Quick Edit, and support
 for everything on the Taxonomy screen.

 This, however, is where things get interesting: this patch also includes a
 revert of [28733]. The problem stems from MySQL's collation behaviour - it
 treats all Unicode Supplementary Characters (which emoji fall under) as
 being equivalent. It's not until MySQL 5.6, wich the addition of the
 `utf8mb4_unicode_520_ci` collation that this changes. So, the behaviour
 introduced in [28733] means that if you already have multiple tags with
 emoji names, inserting a tag without a slug defined will cause the slug to
 be set to the first emoji tag selected, rather than the first emoji tag
 with the same emoji name.

 Simply reverting [28733]'s behaviour obviously isn't the correct solution,
 as it'll re-break #17689. @wonderboymusic - could I get you to dredge up
 your memories of #17689, and give us some thought leadership on other
 options for solving it that could work?

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