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

Example

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.