What are different types of sensitivities used in collations in SQl server?
A collation will indicates the various types sensitivities it will consider while comparing strings. Based on these settings, it will compare the strings.
1) Case sensitivity - If the collation is case-sensitive, This will treat the letters in upper case and lower case as different(Eg: A and a will be treated as different), while comparing strings.
2) Accent sensitivity - If the collation is accent sensitive, It considers accent of the words also while comparing strings.
3) Kana sensitivity - If the collation is Kana-sensitive, Japanese kana characters Hiragana and Katakana will be treated as differently.
4) Width sensitivity - If the collation is width-sensitive, a single-byte character (half-width) and the same character represented as a double-byte character (full-width) will be treated as differently.
SQL Server Interview Questions · · · ·