Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

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 |
+-----------------------+---------+-----+---------+----------+---------+