[wp-trac] [WordPress Trac] #15652: Tags with Accents are Incorrectly Sorted in Cloud

[WordPress Trac]

#15652: Tags with Accents are Incorrectly Sorted in Cloud
--------------------------+-------------------------------------------------
 Reporter:  CatherineBr   |       Owner:                               
     Type:  defect (bug)  |      Status:  new                          
 Priority:  normal        |   Milestone:  Future Release               
Component:  General       |     Version:  3.0.2                        
 Severity:  normal        |    Keywords:  sorting, sort, accents, cloud
--------------------------+-------------------------------------------------

Comment(by Denis-de-Bernardy):

 I suspect that this isn't elegantly fixable unless we store an unaccented
 version of the names. Or use the slug, as scribu suggests, even though the
 slug might be changed by users.

 As an aside, collation is a colorful topic. From the wikipedia:

 http://en.wikipedia.org/wiki/Collation

 "Differences between computer numeric sorting and alphabetic sorting occur
 in Danish and Norwegian (aa is ordered at the end of the alphabet when it
 is pronounced like å, and at the start of the alphabet when it is
 pronounced like a), German (ß is ordered as s + s; ä, ö, ü are ordered as
 a + e, o + e, u + e in phone books, but as o elsewhere, and behind o in
 Austria), Icelandic (ð follows d), Dutch (ij is sometimes ordered as y;
 see IJ: Collation), English (æ is ordered as a + e), and many other
 languages."

 Imho, the only reasonable approach is to leave this up to PHP and MySQL
 respectively, and file bugs on their end when natsort and order by clauses
 don't work as expected on servers with a properly configured locale.
 There's no way we'll get to function as end users would expect in WP
 without excessive amounts of number crunching.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15652#comment:4>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software