What Is Database Collation?

Question

What is Database collation?

Answer

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.