Home > DeveloperSection > Interviews > What are different types of Collation Sensitivity?

Posted on    October-12-2014 11:00 PM

 MSSQL Server Database  MSSQL Server 
 1 Answer(s)
  734  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Posted on    October-12-2014 11:00 PM

1.    Case sensitivity - A and a, B and b, etc.

2.    Accent sensitivity

3.    Kana Sensitivity - When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana sensitive.

4.    Width sensitivity - A single-byte character (half-width) and the same character represented as a double-byte character (full-width) are treated differently than it is width sensitive.

Don't want to miss updates? Please click the below button!

Follow MindStick