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
What is the purpose of DOTNET? Dot Net Is a collection of products like C#, ASp.Net, Vb.Net, XML. The purpose of .Net is that we can simply upgrade and degrade our programs whi

Project Description: I am seeking some automated trading software for the given strategy, I am using Omnesys Nest trader Step 1: Buy one share at current market price (ex:


Project Description: Looking for an internal-use, Manufacturing/ ERP Website developed for use at a Paper Mill. Modules/areas would include Customers, Scheduling, Sales Orders,

How many types of validation controls are provided by ASP.NET   The six main types of validation controls are as follows:- 1) Required Field Validator: This validator che

Construct a .NET wrapper for a C++ Dll - repost Project Description: We have a classic VC++ Dll (source code of DLL not required) that requires a .NET wrapper built by you. U

how can we use entity framework in ASP.Net MVC


I have to develop a Google Map Fix .NET Site on Android(maybe Cross Browser issue) Project Description: A developer has implemented a characteristic which involves data from

What are Assemblies? Assembly is a single deployable unit that have information about the implementation of classes, structures and interfaces. It also keeps the information ab