| DOCUMENTATION | https://docs.snowflake.com |
| English | https://docs.snowflake.com/en/sql-reference/collation |
| Français | https://docs.snowflake.com/fr/sql-reference/collation |
| Deutsch | https://docs.snowflake.com/de/sql-reference/collation |
| 日本語 | https://docs.snowflake.com/ja/sql-reference/collation |
| 한국어 | https://docs.snowflake.com/ko/sql-reference/collation |
| Português | https://docs.snowflake.com/pt/sql-reference/collation |
| Get started | https://docs.snowflake.com/en/user-guide-getting-started |
| Guides | https://docs.snowflake.com/en/guides |
| Developer | https://docs.snowflake.com/en/developer |
| Reference | https://docs.snowflake.com/en/reference |
| Release notes | https://docs.snowflake.com/en/release-notes/overview |
| Tutorials | https://docs.snowflake.com/en/tutorials |
| Status | https://status.snowflake.com |
| Overview | https://docs.snowflake.com/en/reference |
| SQL data types reference | https://docs.snowflake.com/en/sql-reference-data-types |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Function and stored procedure reference | https://docs.snowflake.com/en/sql-reference-functions |
| Class reference | https://docs.snowflake.com/en/sql-reference-classes |
| Scripting reference | https://docs.snowflake.com/en/sql-reference-snowflake-scripting |
| General reference | https://docs.snowflake.com/en/sql-reference |
| Parameters | https://docs.snowflake.com/en/sql-reference/parameters |
| References | https://docs.snowflake.com/en/sql-reference/references |
| Ternary logic | https://docs.snowflake.com/en/sql-reference/ternary-logic |
| Collation support | https://docs.snowflake.com/en/sql-reference/collation |
| Supported collation locales | https://docs.snowflake.com/en/sql-reference/collation-locales |
| SQL format models | https://docs.snowflake.com/en/sql-reference/sql-format-models |
| Object identifiers | https://docs.snowflake.com/en/sql-reference/identifiers |
| Constraints | https://docs.snowflake.com/en/sql-reference/constraints |
| Virtual columns | https://docs.snowflake.com/en/sql-reference/virtual-columns |
| SQL variables | https://docs.snowflake.com/en/sql-reference/session-variables |
| Bind variables | https://docs.snowflake.com/en/sql-reference/bind-variables |
| Transactions | https://docs.snowflake.com/en/sql-reference/transactions |
| Table literals | https://docs.snowflake.com/en/sql-reference/literals-table |
| SNOWFLAKE database | https://docs.snowflake.com/en/sql-reference/snowflake-db |
| Snowflake Information Schema | https://docs.snowflake.com/en/sql-reference/info-schema |
| Metadata fields | https://docs.snowflake.com/en/sql-reference/metadata |
| Conventions | https://docs.snowflake.com/en/sql-reference/conventions |
| Reserved keywords | https://docs.snowflake.com/en/sql-reference/reserved-keywords |
| API reference | https://docs.snowflake.com/en/api-reference |
| Reference | https://docs.snowflake.com/en/reference |
| General reference | https://docs.snowflake.com/en/sql-reference |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-support |
| text strings | https://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes |
| ¶ | https://docs.snowflake.com/sql-reference/collation#overview-of-collation-support |
| Understanding collation | https://docs.snowflake.com/sql-reference/collation#label-collation-definition |
| Uses for collation | https://docs.snowflake.com/sql-reference/collation#label-collation-uses |
| Collation control | https://docs.snowflake.com/sql-reference/collation#label-collation-control |
| ¶ | https://docs.snowflake.com/sql-reference/collation#understanding-collation |
| UPPER | https://docs.snowflake.com/sql-reference/functions/upper |
| LOWER | https://docs.snowflake.com/sql-reference/functions/lower |
| ¶ | https://docs.snowflake.com/sql-reference/collation#uses-for-collation |
| WHERE | https://docs.snowflake.com/sql-reference/constructs/where |
| JOIN | https://docs.snowflake.com/sql-reference/constructs/join |
| ORDER BY | https://docs.snowflake.com/sql-reference/constructs/order-by |
| LIMIT / FETCH | https://docs.snowflake.com/sql-reference/constructs/limit |
| GROUP BY | https://docs.snowflake.com/sql-reference/constructs/group-by |
| Window functions | https://docs.snowflake.com/sql-reference/functions-window |
| Scalar functions | https://docs.snowflake.com/sql-reference/functions |
| Aggregate functions | https://docs.snowflake.com/sql-reference/functions-aggregation |
| Clustering Keys & Clustered Tables | https://docs.snowflake.com/user-guide/tables-clustering-keys |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-control |
| DEFAULT_DDL_COLLATION | https://docs.snowflake.com/sql-reference/parameters#label-default-ddl-collation |
| ALTER DATABASE | https://docs.snowflake.com/sql-reference/sql/alter-database |
| ALTER SCHEMA | https://docs.snowflake.com/sql-reference/sql/alter-schema |
| ALTER TABLE | https://docs.snowflake.com/sql-reference/sql/alter-table |
| CREATE TABLE | https://docs.snowflake.com/sql-reference/sql/create-table |
| Collation precedence in multi-string operations | https://docs.snowflake.com/sql-reference/collation#label-determining-the-collation-used-in-an-operation |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-sql-constructs |
| COLLATE clause for table column definitions | https://docs.snowflake.com/sql-reference/collation#label-collate-clause |
| COLLATE function | https://docs.snowflake.com/sql-reference/collation#label-collate-function |
| COLLATION function | https://docs.snowflake.com/sql-reference/collation#label-collation-function |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collate-clause-for-table-column-definitions |
| Collation precedence in multi-string operations | https://docs.snowflake.com/sql-reference/collation#label-determining-the-collation-used-in-an-operation |
| hybrid tables | https://docs.snowflake.com/user-guide/tables-hybrid |
| Collations on hybrid table columns | https://docs.snowflake.com/sql-reference/sql/create-hybrid-table#label-hybrid-table-collations-disable |
| DESCRIBE TABLE | https://docs.snowflake.com/sql-reference/sql/desc-table |
| COLLATION | https://docs.snowflake.com/sql-reference/collation#label-collation-function |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collate-function |
| COLLATE | https://docs.snowflake.com/sql-reference/functions/collate |
| SELECT | https://docs.snowflake.com/sql-reference/sql/select |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-function |
| COLLATION | https://docs.snowflake.com/sql-reference/functions/collation |
| Collation precedence in multi-string operations | https://docs.snowflake.com/sql-reference/collation#label-determining-the-collation-used-in-an-operation |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-specifications |
| COLLATE | https://docs.snowflake.com/sql-reference/collation#label-collate-clause |
| COLLATE | https://docs.snowflake.com/sql-reference/collation#label-collate-function |
| Supported specifiers | https://docs.snowflake.com/sql-reference/collation#label-supported-specifiers |
| Specification examples | https://docs.snowflake.com/sql-reference/collation#label-collation-specification-examples |
| Supported specifiers | https://docs.snowflake.com/sql-reference/collation#label-supported-specifiers |
| ¶ | https://docs.snowflake.com/sql-reference/collation#specification-examples |
| ¶ | https://docs.snowflake.com/sql-reference/collation#supported-specifiers |
| Differences in sorting when using UTF-8 or locale collation | https://docs.snowflake.com/sql-reference/collation#label-collation-utf8-vs-locale |
| Collation locales supported by Snowflake | https://docs.snowflake.com/sql-reference/collation-locales |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-implementation-details |
| Case-insensitive comparisons | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower |
| Differences in sorting when using UTF-8 or locale collation | https://docs.snowflake.com/sql-reference/collation#label-collation-utf8-vs-locale |
| Collation precedence in multi-string operations | https://docs.snowflake.com/sql-reference/collation#label-determining-the-collation-used-in-an-operation |
| Limited support for collation in built-in functions | https://docs.snowflake.com/sql-reference/collation#label-limited-support-for-collation-in-built-in-functions |
| Performance implications of using collation | https://docs.snowflake.com/sql-reference/collation#label-collation-performance |
| Additional considerations for using collation | https://docs.snowflake.com/sql-reference/collation#label-collation-considerations |
| ¶ | https://docs.snowflake.com/sql-reference/collation#case-insensitive-comparisons |
| Differences when comparing uppercase strings and original strings | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-case-insensitive-comparison-uppercase-original |
| Character weights | https://docs.snowflake.com/sql-reference/collation#label-collation-character-weights |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-when-comparing-uppercase-strings-and-original-strings |
| ¶ | https://docs.snowflake.com/sql-reference/collation#character-weights |
| collation specifications | https://docs.snowflake.com/sql-reference/collation#label-collation-specification |
| ICU | https://en.wikipedia.org/wiki/International_Components_for_Unicode |
| Unicode Collation Algorithm (UCA) | http://www.unicode.org/reports/tr10 |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-in-sorting-when-using-utf-8-or-locale-collation |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-precedence-in-multi-string-operations |
| COLLATE function | https://docs.snowflake.com/sql-reference/collation#label-collate-function |
| ¶ | https://docs.snowflake.com/sql-reference/collation#limited-support-for-collation-in-built-in-functions |
| ¶ | https://docs.snowflake.com/sql-reference/collation#functions-that-support-collation |
| [ NOT ] BETWEEN | https://docs.snowflake.com/sql-reference/functions/between |
| CASE | https://docs.snowflake.com/sql-reference/functions/case |
| CHARINDEX | https://docs.snowflake.com/sql-reference/functions/charindex |
| COALESCE | https://docs.snowflake.com/sql-reference/functions/coalesce |
| CONCAT , || | https://docs.snowflake.com/sql-reference/functions/concat |
| CONTAINS | https://docs.snowflake.com/sql-reference/functions/contains |
| DECODE | https://docs.snowflake.com/sql-reference/functions/decode |
| ENDSWITH | https://docs.snowflake.com/sql-reference/functions/endswith |
| [ NOT ] EQUAL_NULL | https://docs.snowflake.com/sql-reference/functions/equal_null |
| GREATEST | https://docs.snowflake.com/sql-reference/functions/greatest |
| IFF | https://docs.snowflake.com/sql-reference/functions/iff |
| IFNULL | https://docs.snowflake.com/sql-reference/functions/ifnull |
| [ NOT ] ILIKE | https://docs.snowflake.com/sql-reference/functions/ilike |
| ILIKE ANY | https://docs.snowflake.com/sql-reference/functions/ilike_any |
| LEAST | https://docs.snowflake.com/sql-reference/functions/least |
| LEFT | https://docs.snowflake.com/sql-reference/functions/left |
| LENGTH, LEN | https://docs.snowflake.com/sql-reference/functions/length |
| [ NOT ] LIKE | https://docs.snowflake.com/sql-reference/functions/like |
| LIKE ALL | https://docs.snowflake.com/sql-reference/functions/like_all |
| LIKE ANY | https://docs.snowflake.com/sql-reference/functions/like_any |
| LISTAGG | https://docs.snowflake.com/sql-reference/functions/listagg |
| LPAD | https://docs.snowflake.com/sql-reference/functions/lpad |
| MAX | https://docs.snowflake.com/sql-reference/functions/max |
| MIN | https://docs.snowflake.com/sql-reference/functions/min |
| NULLIF | https://docs.snowflake.com/sql-reference/functions/nullif |
| NVL | https://docs.snowflake.com/sql-reference/functions/nvl |
| NVL2 | https://docs.snowflake.com/sql-reference/functions/nvl2 |
| POSITION | https://docs.snowflake.com/sql-reference/functions/position |
| REPLACE | https://docs.snowflake.com/sql-reference/functions/replace |
| RIGHT | https://docs.snowflake.com/sql-reference/functions/right |
| RPAD | https://docs.snowflake.com/sql-reference/functions/rpad |
| SPLIT | https://docs.snowflake.com/sql-reference/functions/split |
| SPLIT_PART | https://docs.snowflake.com/sql-reference/functions/split_part |
| STARTSWITH | https://docs.snowflake.com/sql-reference/functions/startswith |
| SUBSTR , SUBSTRING | https://docs.snowflake.com/sql-reference/functions/substr |
| Collation limitations | https://docs.snowflake.com/sql-reference/collation#label-collation-limitations |
| ¶ | https://docs.snowflake.com/sql-reference/collation#performance-implications-of-using-collation |
| WHERE | https://docs.snowflake.com/sql-reference/constructs/where |
| WHERE | https://docs.snowflake.com/sql-reference/constructs/where |
| WHERE | https://docs.snowflake.com/sql-reference/constructs/where |
| ¶ | https://docs.snowflake.com/sql-reference/collation#additional-considerations-for-using-collation |
| COLLATE | https://docs.snowflake.com/sql-reference/collation#label-collate-function |
| COLLATION | https://docs.snowflake.com/sql-reference/collation#label-collation-function |
| CREATE TABLE | https://docs.snowflake.com/sql-reference/sql/create-table |
| ALTER TABLE | https://docs.snowflake.com/sql-reference/sql/alter-table |
| SELECT | https://docs.snowflake.com/sql-reference/sql/select |
| CREATE VIEW | https://docs.snowflake.com/sql-reference/sql/create-view |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-between-ci-and-upper-lower |
| Differences in comparisons of widths, spaces, and scripts | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-comparisons |
| Differences in handling ignorable code points | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-ignorable |
| Differences when characters are represented by different code points | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-sequences |
| Differences with sequences of code points representing a single character | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-character |
| Differences when changes to case result in multiple code points | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-case |
| Differences in sort order | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-sort |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-in-comparisons-of-widths-spaces-and-scripts |
| Character widths | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-comparisons-widths |
| Types of spaces | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-comparisons-spaces |
| Character scripts | https://docs.snowflake.com/sql-reference/collation#label-collation-upper-lower-differences-comparisons-scripts |
| ¶ | https://docs.snowflake.com/sql-reference/collation#example-of-comparisons-of-characters-with-different-widths |
| ¶ | https://docs.snowflake.com/sql-reference/collation#example-of-comparisons-of-different-types-of-spaces |
| ¶ | https://docs.snowflake.com/sql-reference/collation#example-of-comparisons-of-characters-with-different-scripts |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-in-handling-ignorable-code-points |
| ignorable | https://www.unicode.org/reports/tr10/tr10-36.html#Ignorables_Defn |
| REPLACE | https://docs.snowflake.com/sql-reference/functions/replace |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-when-characters-are-represented-by-different-code-points |
| different sequences of code points can represent the same character | https://en.wikipedia.org/wiki/Unicode_equivalence |
| precomposed character | https://en.wikipedia.org/wiki/Precomposed_character |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-with-sequences-of-code-points-representing-a-single-character |
| CONTAINS | https://docs.snowflake.com/sql-reference/functions/contains |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-when-changes-to-case-result-in-multiple-code-points |
| ¶ | https://docs.snowflake.com/sql-reference/collation#differences-in-sort-order |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-limitations |
| Collation is supported only for strings up to 64 MB | https://docs.snowflake.com/sql-reference/collation#label-collation-limitations-strings-up-to-8mb |
| Collation not supported with UDFs | https://docs.snowflake.com/sql-reference/collation#label-collation-limitations-udfs |
| Collation not supported for strings in VARIANT, ARRAY, or OBJECT values | https://docs.snowflake.com/sql-reference/collation#label-collation-limitations-variant-array-object |
| Clean rooms support only default collation | https://docs.snowflake.com/sql-reference/collation#label-collation-limitations-clean-rooms |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-is-supported-only-for-strings-up-to-64-mb |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-not-supported-with-udfs |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-not-supported-for-strings-in-variant-array-or-object-values |
| ¶ | https://docs.snowflake.com/sql-reference/collation#clean-rooms-support-only-default-collation |
| ¶ | https://docs.snowflake.com/sql-reference/collation#collation-examples |
| COLLATION | https://docs.snowflake.com/sql-reference/collation#label-collation-function |
| DESCRIBE TABLE | https://docs.snowflake.com/sql-reference/sql/desc-table |
| Visit Snowflake | https://www.snowflake.com |
| Join the conversation | https://community.snowflake.com/s/ |
| Develop with Snowflake | https://developers.snowflake.com |
| Share your feedback | https://docs.snowflake.com/feedback |
| Read the latest on our blog | https://www.snowflake.com/blog/ |
| Get your own certification | https://learn.snowflake.com |
| Privacy Notice | https://www.snowflake.com/privacy-policy/ |
| Site Terms | https://www.snowflake.com/legal/snowflake-site-terms/ |
| Snowflake Python APIs | https://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview |
| Snowflake REST APIs | https://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api |
| Snowflake CLI | https://docs.snowflake.com/developer-guide/snowflake-cli/index |
| Overview of collation support | https://docs.snowflake.com/sql-reference/collation#overview-of-collation-support |
| Understanding collation | https://docs.snowflake.com/sql-reference/collation#understanding-collation |
| Uses for collation | https://docs.snowflake.com/sql-reference/collation#uses-for-collation |
| Collation control | https://docs.snowflake.com/sql-reference/collation#collation-control |
| Collation SQL constructs | https://docs.snowflake.com/sql-reference/collation#collation-sql-constructs |
| COLLATE clause for table column definitions | https://docs.snowflake.com/sql-reference/collation#collate-clause-for-table-column-definitions |
| COLLATE function | https://docs.snowflake.com/sql-reference/collation#collate-function |
| COLLATION function | https://docs.snowflake.com/sql-reference/collation#collation-function |
| Collation specifications | https://docs.snowflake.com/sql-reference/collation#collation-specifications |
| Specification examples | https://docs.snowflake.com/sql-reference/collation#specification-examples |
| Supported specifiers | https://docs.snowflake.com/sql-reference/collation#supported-specifiers |
| Collation implementation details | https://docs.snowflake.com/sql-reference/collation#collation-implementation-details |
| Case-insensitive comparisons | https://docs.snowflake.com/sql-reference/collation#case-insensitive-comparisons |
| Differences in sorting when using UTF-8 or locale collation | https://docs.snowflake.com/sql-reference/collation#differences-in-sorting-when-using-utf-8-or-locale-collation |
| Collation precedence in multi-string operations | https://docs.snowflake.com/sql-reference/collation#collation-precedence-in-multi-string-operations |
| Limited support for collation in built-in functions | https://docs.snowflake.com/sql-reference/collation#limited-support-for-collation-in-built-in-functions |
| Performance implications of using collation | https://docs.snowflake.com/sql-reference/collation#performance-implications-of-using-collation |
| Additional considerations for using collation | https://docs.snowflake.com/sql-reference/collation#additional-considerations-for-using-collation |
| Differences between ci and upper / lower | https://docs.snowflake.com/sql-reference/collation#differences-between-ci-and-upper-lower |
| Differences in comparisons of widths, spaces, and scripts | https://docs.snowflake.com/sql-reference/collation#differences-in-comparisons-of-widths-spaces-and-scripts |
| Differences in handling ignorable code points | https://docs.snowflake.com/sql-reference/collation#differences-in-handling-ignorable-code-points |
| Differences when characters are represented by different code points | https://docs.snowflake.com/sql-reference/collation#differences-when-characters-are-represented-by-different-code-points |
| Differences with sequences of code points representing a single character | https://docs.snowflake.com/sql-reference/collation#differences-with-sequences-of-code-points-representing-a-single-character |
| Differences when changes to case result in multiple code points | https://docs.snowflake.com/sql-reference/collation#differences-when-changes-to-case-result-in-multiple-code-points |
| Differences in sort order | https://docs.snowflake.com/sql-reference/collation#differences-in-sort-order |
| Collation limitations | https://docs.snowflake.com/sql-reference/collation#collation-limitations |
| Collation is supported only for strings up to 64 MB | https://docs.snowflake.com/sql-reference/collation#collation-is-supported-only-for-strings-up-to-64-mb |
| Collation not supported with UDFs | https://docs.snowflake.com/sql-reference/collation#collation-not-supported-with-udfs |
| Collation not supported for strings in VARIANT, ARRAY, or OBJECT values | https://docs.snowflake.com/sql-reference/collation#collation-not-supported-for-strings-in-variant-array-or-object-values |
| Clean rooms support only default collation | https://docs.snowflake.com/sql-reference/collation#clean-rooms-support-only-default-collation |
| Collation examples | https://docs.snowflake.com/sql-reference/collation#collation-examples |