Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

What does collation mean in SQL, and what does it do?

1 Answer

0 votes
by (40.7k points)

Collation can be just considered as sort order.

In English (and it's strange cousin, American), collation can be a simple matter consisting of ordering by the ASCII code.

In European languages with all their accents and other features, collation changes. 

For example, though the different accented forms of a may exist at disparate code points, they may all need to be sorted as if they were the same letter.

Browse Categories