SQL Server : What are different type of Collation Sensitivity?

Case sensitivity

A and a, B and b, etc.

 

Accent sensitivity

a and á, o and ó, etc.

 

Kana Sensitivity

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

 

Width sensitivity

When a single-byte character (half-width) and the same character when represented as a double-byte character (full-width) are treated differently then it is width sensitive.

 

No comments:

Post a Comment