[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:  closed
 Priority:  normal        |   Milestone:
Component:  General       |     Version:  4.3
 Severity:  normal        |  Resolution:  duplicate
 Keywords:                |     Focuses:
--------------------------+------------------------

Comment (by geza.miklo):

 No it isn't a duplicate. Accents are supported is appropriate encoding is
 used. We are using utf-8. So I can add accented tags. But if I add szél at
 first I cannot add szel anymore. But in hungarian szél is wind and szel
 means cut. So they are completely different things.

 The problem lies in the part createing the slug and checking for the
 existence of the word as tag name. You can see that szél and szel should
 not be the same name. However mysql's comparison depends on the database
 collation. Using the default these two queries' results will be the same:

 SELECT * FROM wp_tags WHERE name = 'szel';
 -- lists szel and szél if both exists

 SELECT * FROM wp_tags WHERE name = 'szél';
 -- lists szel and szél two is both exits

 SELECT * FROM wp_tags WHERE BINARY name = 'szel';
 -- will list only szel

 SELECT * FROM wp_tags WHERE BINARY name = 'szél';
 -- will list only szél

 Please reconsider marking it a duplicate.

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