Back

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

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

1 Answer

0 votes
by (40.4k 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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.2k users

Browse Categories

...