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
I need a Windows SharePoint Services or Similar Solution My company desires a reliable way of managing the documents online for each of its clients. The solution would want t

Full time contractual programming position (mostly scraping, databasing) Project Description: This is a full time contractual role needed for a sports advisory service. We ar

The ASP.NET impersonation is totally controlled by entries in the applications web.config file. Default setting is "no impersonation". You can explicitly describe  that ASP.NET sho

I need very easy project in metatrader Project Description: I have 3 indicators.... ADX, emas crossover and macd crossover! They are all signals, arrows! But i would like to

We need in ASP.NET Mvc site I have project should be done with MVC.NET technology. In general- I have by now the site Layout (Html-js-css) I need- a) Simple CMS allo

Explain the WSDL. WSDL is a short form for Web Services Description Language, which is used to explain a Web service in terms of the messages that it forms and accepts. The WS

What is the difference between Server.Transfer and response.Redirect? The difference  between the Server.Transfer and the response.Redirect them are as follows:- 1)Response.

CTS(Common Type System) : In order that the two language communicate smoothly CLR has CTS (Common Type System). Example in VB you have "Integer" and in C++ you have "long" these d

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

What is an interface and what is an abstract class? Please, expand by examples of using both. Explain why.   In a interface class, all methods are abstract without execut