interview

Home / DeveloperSection / Interviews / What is the purpose of using COLLATE in a query?

Ask Question
Amit Singh

Amit Singh

Follow

Can you answer this question?

Answer

4 Answers

hanmandlu vasani

hanmandlu vasani

02-May-2014


Amit Singh

Amit Singh

03-May-2011

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

Amit Singh

03-May-2011
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

Amit Singh

03-May-2011
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.

Liked By