What is Collation in SQL Server?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 25688


Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types, and character width.




Collation according to language


Note: - Different languages will have different sort orders.


Case Sensitivity


If A and a, B and b, etc. are treated in the same way, then it is case-insensitive. A computer treats A and a differently because it uses ASCII code to differentiate the input. The ASCII value of A is 65, while a is 97. The ASCII value of B is 66 and b is 98.


Accent Sensitivity


If a and A, o and O are treated in the same way, then it is accent-insensitive. A computer treats a and A differently because it uses ASCII code for differentiating the input. The ASCII value of a is 97 and A 225. The ASCII value of o is 111 and O is 243.


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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Gowthami on: 10/17/2012
can you give me clear explanation and usage of collation.....
thanks in advance

Login to post response