What is the purpose of using COLLATE in a query?

Question

Amit Singh · Answer

The term, collation, refers to a set of rules that determine

how data is sorted and compared. In Microsoft? SQL Server

2000, it is not required to separately specify code page and

sort order for character data, and the collation used for

Unicode data. Instead, specify the collation name and

sorting rules to use.

Amit Singh · Answer

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.

Amit Singh · 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.

interview

What is the purpose of using COLLATE in a query?

Can you answer this question?

4 Answers