Google News
logo
SQL Server - Interview Questions
What is collation sensitivity? Explain different types.
Collation sensitivity is used to define the rules for sorting and comparing the strings of character data. The basic rule for sorting a character data are correct character sequence, Case-sensitivity, character width, and accent marks, etc.
 
Different types of collation sensitivity :
 
Case Sensitivity : Case sensitivity defines every character with a unique value, as alphabet characters A and a are treated individually, as they have different ASCII values for a computer language
 
Accent sensitivity : Accent sensitivity is related that whether the accent is off or not, as a and á both should be treated differently
 
Kana sensitivity : Kana sensitivity defines the difference between two Japanese words: Hiragana and Katakana
 
Width sensitivity : It differentiates between a single-byte character (half- width) and representation of the double-byte character of the same character
Advertisement