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

Posted on    November-04-2011 6:51 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  2677  View(s)
Rate this:

Chintoo Semi

Total Post:79

Posted on    November-04-2011 12:00 AM

    There are basically three types of Collation Sensitivity: 
     1. Case sensitivity - A and a, B and b, etc.
     2. Accent sensitivity
     3. 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