SHOW COLLATION

The SHOW COLLATION statement shows the collations supported by NebulaGraph.

Currently available types are: utf8_bin, utf8_general_ci, utf8mb4_bin, and utf8mb4_general_ci.

• When the character set is utf8, the default collate is utf8_bin.

• When the character set is utf8mb4, the default collate is utf8mb4_bin.

• Both utf8mb4_bin and utf8mb4_general_ci are case-insensitive.

Syntax

SHOW COLLATION;

Example

nebula> SHOW COLLATION;
+------------+---------+
| Collation  | Charset |
+------------+---------+
| "utf8_bin" | "utf8"  |
+------------+---------+

Parameter	Description
Collation	The name of the collation.
Charset	The name of the character set with which the collation is associated.

---

Last update: February 19, 2024