Sql Interview Question #3: What are different types of collation sensitivity?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged case collation kana katakana sensitivity width on by .

Sql Interview Question

What are different types of collation sensitivity?

Solution

Case sensitivity – A and a, B and b, etc.

Accent sensitivity – a and á, o and ó, etc.

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

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

 

Thanks for reading this article,

Next steps :

  1. Share this with your colleagues because Sharing is Learning
  2. Comment below if you need any assistance