WHAT IS THE PURPOSE OF USING COLLATE IN A QUERY?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 2411  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    What is the purpose of using COLLATE in a query?

    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.

  1. Amit Singh

    Post:565

    Points:2825
    What is the purpose of using COLLATE in a query?

    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.

  1. Amit Singh

    Post:565

    Points:2825
    What is the purpose of using COLLATE in a query?

    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.

  1. hanmandlu vasani

    Post:30

    Points:150
    What is the purpose of using COLLATE in a query?


Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!