SHOW COLLATION

Description

This statement lists collations supported by MatrixOne. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to match. The WHERE clause can be given to select rows using more general conditions.

Syntax

  1. > SHOW COLLATION
  2.     [LIKE 'pattern' | WHERE expr]

Examples

  1. mysql> show collation;
  2. +-------------+---------+------+----------+---------+
  3. | Collation   | Charset | Id   | Compiled | Sortlen |
  4. +-------------+---------+------+----------+---------+
  5. | utf8mb4_bin | utf8mb4 |   46 | Yes      |       1 |
  6. +-------------+---------+------+----------+---------+
  7. 1 row in set (0.00 sec)
  9. mysql> show collation like '%';
  10. +-------------+---------+------+----------+---------+
  11. | Collation   | Charset | Id   | Compiled | Sortlen |
  12. +-------------+---------+------+----------+---------+
  13. | utf8mb4_bin | utf8mb4 |   46 | Yes      |       1 |
  14. +-------------+---------+------+----------+---------+
  15. 1 row in set (0.00 sec)
  17. mysql> show collation where 'Charset'='utf8mb4';
  18. +-------------+---------+------+----------+---------+
  19. | Collation   | Charset | Id   | Compiled | Sortlen |
  20. +-------------+---------+------+----------+---------+
  21. | utf8mb4_bin | utf8mb4 |   46 | Yes      |       1 |
  22. +-------------+---------+------+----------+---------+
  23. 1 row in set (0.00 sec)