3 ms·
One more interesting implication of 2: you might want to let the user specify what to use for sorting. Although that seems problematic to me.
by jchrisa 12y ago
One more interesting implication of 2: you might want to let the user specify what to use for sorting. Although that seems problematic to me.
- pornel 12y agoInternationalized sorting is a whole new can of worms, and there are mutually exclusive rules in different languages. http://www.unicode.org/reports/tr10/ http://www.unicode.org/reports/tr10/
- frobozz 12y agoAnd (for names, at least) in the same language in different contexts. See https://en.wikipedia.org/wiki/Mac_and_Mc_together https://en.wikipedia.org/wiki/Mac_and_Mc_together (poor article, but the gist is there) I believe the same is true of de~ and van~ surnames, which are sometimes ordered by the first capital (i.e. van Houten comes before de Koninck), and sometimes not. This means that offering a user the option of presenting a sort version of their name still leaves them in the dark as to what comes before or after it.
- HNJohnC 12y agoWhich is why, I guess, going on 4 years now Mongo has has an open issue to implement unicode sorting and still has not.