What is the purpose of using COLLATE in a query?
Q
What is the purpose of using COLLATE in a query?
✍: Guest
A
Answer1.
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.
Answer2.
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.
2014-10-10, 2001👍, 0💬
Related Topics:
