Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
Can you explain collation sequence in sql server
Can you explain collation sequence in sql server?
✍: Guest
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.
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 á, 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.
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.
2007-11-02, 4802👍, 0💬
Popular Posts:
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
How can you implement MVC pattern in ASP.NET? The main purpose using MVC pattern is to decouple the ...
What Happens If One Row Has Missing Columns? - XHTML 1.0 Tutorials - Understanding Tables and Table ...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
Can Sub Procedure/Function Be Called Recursively? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...