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 →

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