Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

SHOW COLLATION

Syntax

SQL

SHOW COLLATION
   [LIKE '<collation_pattern>']
   [WHERE <predicate> [AND <predicate>] ]

<predicate> := Charset = '<charset_name>' | Collation = '<collation_name>'

Output

This command shows the collations available and the character sets to which they apply. Each character set typically has multiple available collations. There is one default collation per character set.

The following table describes the columns returned by the SHOW COLLATION command.

Column	Description
Collation	Name of the collation.
Charset	The character set to which the collation applies.
Id	The internal Id of the collation.
Default	Indicates if this collation is the default for the Charset.
Compiled	Included for MySQL compatibility.
Sortlen	Included for MySQL compatibility.

Remarks

Refer to Collations Supported for information on supported collations.
Refer to Specifying Character Set and Collation for Clusters on specifying collations.

Example

SQL

SHOW COLLATION
LIKE '%danish%'
WHERE Charset = 'utf8mb4';

+-----------------------+---------+-----+---------+----------+---------+
| Collation             | Charset | Id  | Default | Compiled | Sortlen |
+-----------------------+---------+-----+---------+----------+---------+
| utf8_danish_ci        | utf8    | 203 |         | Yes      |       8 |
+-----------------------+---------+-----+---------+----------+---------+

SHOW COLLATION

On this page

Syntax

Output

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?