# SHOW COLLATION

Lists available collations and character sets.

## 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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/character-encoding/collations-supported.md) for information on supported collations.
* Refer to [Specifying Character Set and Collation for Clusters](https://docs.singlestore.com/db/v9.1/reference/sql-reference/character-encoding/specifying-character-set-and-collation-for-clusters.md) on specifying collations.

## Example

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

```

```output

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

***

Modified at: October 28, 2025

Source: [/db/v9.1/reference/sql-reference/show-commands/show-collation/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-collation/)

(An index of the documentation is available at /llms.txt)