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

On this page