Interview Questions

What is the purpose of using COLLATE in a query?

.NET Database ,COM interop,and .NET deployment questions and answers


(Continued from previous question...)

What is the purpose of using COLLATE in a query?

Answer1.
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.

Answer2.
COLLATE is a clause that can be applied to a database definition or a column definition to define the collation, or to a character string expression to apply a collation cast.

(Continued on next question...)

Other Interview Questions