0 votes
in Sql by
What is Collation? What are the different types of Collation Sensitivity?

1 Answer

0 votes
by

Collation refers to a set of rules that determine how data is sorted and compared. Rules defining the correct character sequence are used to sort the character data. It incorporates options for specifying case-sensitivity, accent marks, kana character types and character width. Below are the different types of collation sensitivity:

Case sensitivity: A and a are treated differently.

Accent sensitivity: a and á are treated differently.

Kana sensitivity: Japanese kana characters Hiragana and Katakana are treated differently.

Width sensitivity: Same character represented in single-byte (half-width) and double-byte (full-width) are treated differently.

Related questions

0 votes
asked Jun 15, 2023 in Sql by Robin
0 votes
asked Nov 5, 2021 in Sql by rajeshsharma
...