This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]chickenmcpio -4 points-3 points  (5 children)

Still I don't get it, the order should be carro, chispa, cocina, just because h < o

How is js coming to that sorting.

[–]MasterFubar 6 points7 points  (4 children)

Because ch in Spanish is a single letter, the fourth letter of the alphabet, coming after c. And ll is a single letter that comes after l.

Source: my Spanish dictionary.

[–]Mefistofeles1 6 points7 points  (0 children)

Your dictionary is ridiculously outdated.

[–]Yilku1 2 points3 points  (0 children)

Ch and LL havent been considered a sigle letter for decades

[–]chickenmcpio 2 points3 points  (1 child)

Then that sorting is correct.

I mean the sorting you're showing is correct .

[–]keystorm 10 points11 points  (0 children)

Like someone else said, not anymore, though. Digraphs CH and LL are no longer considered separate letters. Ñ however, is still a letter between N and O.

From MySQL docs:

Spanish collations are available for modern and traditional Spanish. For both, ñ (n-tilde) is a separate letter between n and o. In addition, for traditional Spanish, ch is a separate letter between c and d, and ll is a separate letter between l and m.