Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
4 views
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.

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...