WHAT IS THE PURPOSE OF USING COLLATE IN A QUERY?

Amit Singh

Total Post:0

Points:0
Posted by  Amit Singh
 2673  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:562

    Points:2810
    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.

      Modified On Mar-27-2018 12:02:32 AM
  1. Amit Singh

    Post:562

    Points:2810
    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:562

    Points:2810
    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:27

    Points:135
    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!