Question

What are different types of sensitivities used in collations in SQl server?

Answer

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.

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·