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

Ask an Expert

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

Write your message here..

Related Questions

Windows 8.1 project - asset management slate app, I need Windows 8.1 Projec... I need Windows 8.1 Project, Asset management slate App Project Description: We are seeking a Windows 8 app developer with PROVABLE experience to prepare a project and asset m

Operator overloading in .net, What is Operator Overloading in .NET? It ... What is Operator Overloading in .NET? It gives a way to define and use operators like +, -, and / for user-defined classes or structs. It permits us to define/redefine the way

I need a web application ui modernization, I need a Web Application UI Mode... I need a Web Application UI Modernization - Preliminary Technology Assessment We are seeking to overhaul a 10-year old enterprise application, CRM-related as well as web-based t

Interface, What is a Interface? The Interface is a contract that descri... What is a Interface? The Interface is a contract that describes the signature of the functionality. So when a class is implementing a interface it says to the outer world, that

Use of "must inherit" keyword in vb.net, What is the use of "Must Inherit" ... What is the use of "Must Inherit" keyword in VB.NET? If you want to create an abstract class in the VB.NET it is done by using the "MustInherit" keyword.You can't create an obj

Learning management system, I am looking for learning management software (... I am looking for learning management software (LMS) preferably in ASP.NET and Microsoft SQL/ MYSQL server as the database. The broad scope of the system could be 1. User managem

Training and placement cell, Training and placement cell Project Descrip... Training and placement cell Project Description: It is about placement and training cell of any college. I have made this for one college. If needed, i can modify it. Student

Define an event, Define an event. Whenever an action takes place in a c... Define an event. Whenever an action takes place in a class, that class gives a notification to other classes or objects that are assigned to perform certain tasks. These notifi

How different are interface and abstract class in .net, How different are i... How different are interface and abstract class in .Net? Abstract classes cannot be instantiated it can have or cannot have abstract method basically called as must inherit as t

I need chatting application, I need Beautiful Chatting Application Proje... I need Beautiful Chatting Application Project Description: I need a beautiful chatting application created that has both private as well as public chat system. The chatting c