SHOW COLLATION

语法说明

显示 MatrixOne 支持字符集的排序规则。默认情况下，SHOW COLLATION 的输出包括所有可用的排序规则。LIKE 子句（如果存在）指示要匹配的排序规则名称。WHERE 子句可以使用更一般的条件来选择行。

语法结构

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

示例

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)