Sql Server Interview Question #12 :What are the different types of Collation Sensitivity?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged collation different sensitivity server sql on by .

Sql Server Interview Question:

What are the different types of Collation Sensitivity?

Answer

  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.

 

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

Powered by CodeReview – Let’s make it Better!