[wp-trac] [WordPress Trac] #33864: Cannot add accented tag if non-accented look-alike exists (eg. szel, szél)

[WordPress Trac]

#33864: Cannot add accented tag if non-accented look-alike exists (eg. szel, szél)
------------------------------------+-----------------------
 Reporter:  geza.miklo              |       Owner:
     Type:  defect (bug)            |      Status:  reopened
 Priority:  normal                  |   Milestone:  4.4
Component:  Taxonomy                |     Version:  4.3
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:
------------------------------------+-----------------------

Comment (by geza.miklo):

 Please note, that in foreign languages other than english two words with
 the same slug can have completely different meaning.

 By the way now you cannot add both "resume" and "résumé". See my problem.
 So you brought an english example which shows that the current is not the
 best behavior.

 I understand your concerns but this is not an acceptable behaviour in non
 english languages having accented characters. We've changed the collation
 on the database. Now it's sideeffect is:
 * lowercase words are on the end of the list
 * The whole stuff got case-sensitive

 Seems the best solution can be using get_results and check the match in
 PHP.

 Replying to [comment:7 pento]:
 > From a MySQL perspective, inefficient index use is the biggest concern.
 >
 > I also don't like the idea of just dropping the collation behaviour -
 while it causes incorrect results in this instance, dropping it is just as
 likely to cause other incorrect results. For example, using a generic
 english keyboard, I'd want to type "resume" and have it match "résumé",
 because typing accented characters is not fun.

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