What Is The Purpose Of Using Collate In A Query?

1.	What Is The Purpose Of Using Collate In A Query?
Answer» Collation refers to a set of rules that determine how data is SORTED and compared. CHARACTER data is sorted USING rules that define the correct character sequence, with options for SPECIFYING case-sensitivity, accent marks, kana character TYPES and character width. Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.

Answer»

Collation refers to a set of rules that determine how data is SORTED and compared. CHARACTER data is sorted USING rules that define the correct character sequence, with options for SPECIFYING case-sensitivity, accent marks, kana character TYPES and character width.

Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.

Discussion

No Comment Found

Related InterviewSolutions

What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?
What Is Task?
How Does You Handle This Com Components Developed In Other Programming Languages In .net?
How Do U Call And Execute A Stored Procedure In .net?
How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?
What Is The Stuff Function And How Does It Differ From The Replace Function?
Explain Differences Between Framework 1.0 And Framework 1.1?
What Are The Differences Between User Control And Web Control And Custom Control?
How Do Sql Server 2000 And Xml Linked? What Is Sql Server Agent?
If We Write Any Code For Datagrid Methods, What Is The Access Specifier Used For That Methods In The Code Behind File And Why And How? Give An Example?