Skip to content

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: December 8, 2022