# **SHOW COLLATION**

## **Grammar Description**

Shows MatrixOne supports collation rules for character sets. By default, the output of `SHOW COLLATION` includes all available collation rules. The `LIKE` clause (if present) indicates the collation name to match. The `WHERE` clause can use more general conditions to select rows.

## **Grammar Structure**

```sql
SHOW COLLATION
    [LIKE 'pattern' | WHERE expr]
```

## **Example**

```text
mysql> show collation;
+-------------------+-----------+----------------+
| Collation | Charset | Id | Compiled | Sortlen |
+-------------------+-----------+----------------+
| utf8mb4_bin | utf8mb4 | 46 | Yes | 1 |
+-------------------+-----------+----------------+
1 row in set (0.00 sec)

mysql> show collation like '%';
+-------------------+-----------+----------------+
| Collation | Charset | Id | Compiled | Sortlen |
+-------------------+-----------+----------------+
| utf8mb4_bin | utf8mb4 | 46 | Yes | 1 |
+-------------------+-----------+----------------+
1 row in set (0.00 sec)

mysql> show collation where 'Charset'='utf8mb4';
+-------------------+-----------+----------------+
| Collation | Charset | Id | Compiled | Sortlen |
+-------------------+-----------+----------------+
| utf8mb4_bin | utf8mb4 | 46 | Yes | 1 |
+-------------------+-----------+----------------+
1 row in set (0.00 sec)
```