What Is Database Collation?link
Updated November 29, 2023
What is Database collation?
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.
The most common collation is UTF-8, which can represent any character in the Unicode standard.
For Snowflake, the default collation is UTF-8.