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

Posted on    January-16-2015 10:40 PM

 MSSQL Server SQL Server 2012 
Ratings:
 1 Answer(s)
  513  View(s)
Rate this:

Chintoo Semi

Total Post:79

Points:395
Posted on    January-16-2015 11:40 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