What Is Database Collation?link

Updated 11 days ago

Questionlink

What is Database collation?

Answerlink

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.