Collation sequence in sql server, DOT NET Programming

Explain collation sequence in sql server.

The Collation sequences are the set of rules which determine how the data is sorted and compared. The Sorting rules can be defined with options with accent marks, case-sensitivity,  kana character types & character width.

Case sensitivity:

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

Accent sensitivity:

If a and á, o and ó are treated in the similar way, then it is accent-insensitive. A computer treats a and á differently as it uses ASCII code for differentiating the input. The ASCII value of a is 97 and á is 225. And the ASCII value of o is 111 & ó is 243.

Kana Sensitivity

When Japanese kana characters Hiragana & Katakana are treated differently, it is known as Kana sensitive.

Width sensitivity

When a single-byte character (half-width) and the similar character when represented as a double-byte character (full-width) are treated differently than it is width sensitive.

Posted Date: 9/25/2012 3:52:50 AM | Location : United States







Related Discussions:- Collation sequence in sql server, Assignment Help, Ask Question on Collation sequence in sql server, Get Answer, Expert's Help, Collation sequence in sql server Discussions

Write discussion on Collation sequence in sql server
Your posts are moderated
Related Questions
Have you ever worked with Microsoft Application Blocks, if yes then which? The Application Blocks are C# & the VB.NET classes distributed as the Visual Studio projects which ca

Are you available to discuss about my project. I'd like you to show first and then accept the project provided if we both agree to continue with each other. Skills required:

Write the basic syntax of a LINQ query in Visual Basic as well as in C#. In Visual Basic, the basic syntax of a LINQ query begins with the from clause and ends with the Select

How do you implement prototype pattern in .NET? The Cloning is achieved by using the ICloneable of the System namespace. It has a "Clone" method that actually returns the refer

The Cache object is always defined in the System.Web.Caching namespace. You can get the reference to the Cache object by either using the Cache property of the HttpContext class in

What are the problems that can occur if you do not implement locking properly in SQL SERVER? The problems that occur if you do not implement locking properly in SQL SERVER is a

Describe session handling in a web farm, how does it work and what are the limits ?    In ASP.NET there are three ways to manage session objects. One support the in-proc mechani

Project Description: I need a SharePoint Developer tutor to teach me the development of SharePoint from scratch. We will be communicating through TeamViewer and Skype. I have ac

Give a brief introduction on side-by-side execution. Can two applications, one using private assembly and the other using the shared assembly be stated as side-by-side executables?

You can post back to any of the page and pages in other application, too. But if you are posting pages to other application, the PreviousPage property will return null. This is an