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
Improve an existing web application and design (ASP C# Azure Project Description: I want an experience programmer to take my Proof of Concept web app to a professional level.

Need Software Reconfiguration Project Description: I have a small program -exe that after selecting an item from the menu it start an .xls file and executes a security proces

In this assignment you will create a Windows application that mimic the ILDASM application. Your application should have at least the following features: 1. A multi-form applica

What are different transaction levels in SQL SERVER? The Transaction Isolation level decides how is the one process isolated from theother process. Using the transaction levels

Decision Making and Branching - C# Program Need Programming help on Decision Making and Branching in C#.

Briefly explain what user controls are and what server controls are and the differences among the two.   An ASP.NET control (sometimes known as a server control) is a server-si

What are value types and reference types?  Value type - bool, byte, chat, decimal, double, enum , float, int, long, sbyte, short, strut, uint, ulong, ushort. Value types are

wiConstellation WEB site Project Description: Creation of a dynamic corporate WEB site with administration panel, requirement collaboration, product definition, Q&A, user man

Explain MVC and how it is diffrennt from Asp.net

Professional TELERIK Bind MS ACCESS Required: 1. Including custom fields to the Schedule. 2. Schedule Calendar Sync with Outlook 3. Selecting display in Schedule res