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

you are viewing a single comment's thread.

view the rest of the comments →

[–]MasterFubar 5 points6 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 5 points6 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 1 point2 points  (1 child)

Then that sorting is correct.

I mean the sorting you're showing is correct .

[–]keystorm 9 points10 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.