Can you explain collation sequence in sql server
Can you explain collation sequence in sql server?
First let’s define collation.
Collation sequences are set of rules which determine how the data is sorted and compared. Sorting rules can be defined with options with case-sensitivity, accent marks, kana character types and character width.
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.
If a and á, o and ó are treated in the same way, then it is accent-insensitive. A computer treats a and á differently because it uses ASCII code for differentiating the input. The ASCII value of a is 97 and áis 225. The ASCII value of o is 111 and ó is 243.
When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana sensitive.
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.
2007-11-02, 4679👍, 0💬
How To Compile a JUnit Test Class? Compiling a JUnit test class is like compiling any other Java cla...
Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...
If we have two version of same assembly in GAC how do we make a choice ? OK first let’s try to under...
Have you ever worked with Microsoft Application Blocks, if yes then which? Application Blocks are C#...
How To Get the Uploaded File Information in the Receiving PHP Script? Once the Web server received t...