SHOW COLLATION
Descriptionβ
In Doris, the SHOW COLLATION command is used to display the character set collations available in the database. A collation is a set of rules that determine how data is sorted and compared. These rules affect the storage and retrieval of character data. Doris currently mainly supports the proofreading method utf8mb4_0900_bin.
Syntaxβ
SHOW COLLATION
Result Fieldsβ
The SHOW COLLATION command returns the following fields:
- Collation: The collation name
- Charset: The character set
- Id: The collation's ID
- Default: Whether this is the default collation for the character set
- Compiled: Whether the collation is compiled
- Sortlen: Sort length
Examplesβ
show collation;
+------------------+---------+------+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+------------------+---------+------+---------+----------+---------+
| utf8mb4_0900_bin | utf8mb4 | 33 | Yes | Yes | 1 |
+------------------+---------+------+---------+----------+---------+
Noticeβ
In Doris, although it is compatible with MySQL's commands for setting the collation, the setting actually does not take effect. When executed, Doris will always use utf8mb4_0900_bin as the comparison rule.
