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

Posted on    May-03-2011 12:41 AM

 MSSQL Server MSSQL Server 
Ratings:
 4 Answer(s)
  2058  View(s)
Rate this:

Amit Singh

Total Post:565

Points:2825
Posted on    May-03-2011 12:00 AM

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

Total Post:565

Points:2825
Posted on    May-03-2011 12:00 AM

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

Total Post:565

Points:2825
Posted on    May-03-2011 12:00 AM

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.

hanmandlu vasani

Total Post:30

Points:150
Posted on    May-02-2014 12:00 AM



Don't want to miss updates? Please click the below button!

Follow MindStick