SHOW COLLATION

The SHOW COLLATION command lists available collations and character sets.

Syntax

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

Example

SHOW COLLATION
LIKE '%danish%'
WHERE Charset = 'utf8mb4';
+-----------------------+---------+-----+---------+----------+---------+
| Collation             | Charset | Id  | Default | Compiled | Sortlen |
+-----------------------+---------+-----+---------+----------+---------+
| utf8_danish_ci        | utf8    | 203 |         | Yes      |       8 |
+-----------------------+---------+-----+---------+----------+---------+

Last modified:

Was this article helpful?