collations table function

Applies to: Databricks SQL Databricks Runtime 16.1 and above

Returns the set of supported collations in Azure Databricks.

Syntax

collations()

Arguments

This function takes no arguments.

Returns

A set of rows composed of two columns:

• CATALOG STRING NOT NULL: Always SYSTEM.
• SCHEMA STRING NOT NULL: Always BUILTIN.
• NAME STRING NOT NULL: The name of the collation.
• LANGUAGE STRING : The language of the collation, NULL for non-ICU collations.
• COUNTRY STRING : The country of the collation, NULL for non-ICU collations.
• ACCENT_SENSITIVITY STRING NOT NULL: The accent sensitivity of the collation. One of ACCENT_SENSIITVE, ACCENT_INSENSITIVE
• CASE_SENSITIVITY STRING NOT NULL: The case sensitivity of the collation. One of CASE_SENSIITVE, CASE_INSENSITIVE
• PAD_ATTRIBUTE STRING NOT NULL: NO_PAD if sensitive to trailing blanks. RTRIM if insensitive to trailing blanks.
• ICU_VERSION STRING : The ICU version of the collation, NULL for non-ICU collations.

All columns use default collation.

Examples

> SELECT name FROM collations()
   WHERE language = 'German'
     AND case_sensitivity = 'CASE_INSENSITIVE';
 de_AUT_CI
 de_AUT_CI_AI
 de_CI
 de_CI_AI

Supported collations