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

> SHOW COLLATION
    [LIKE 'pattern' | WHERE expr]

Example

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)