Syntax
COLLATION(str)
Purpose
You can call this function to return the collation of the str string.
You can execute the SHOW COLLATION statement to view the collations supported by OceanBase Database.
Examples
obclient> SELECT COLLATION("oceanbase");
+------------------------+
COLLATION("oceanbase")
+------------------------+
utf8mb4_general_ci
+------------------------+
1 row in set (0.00 sec)
obclient> SELECT COLLATION("oceanbase" COLLATE utf8mb4_bin);
+--------------------------------------------+
COLLATION("oceanbase" COLLATE utf8mb4_bin)
+--------------------------------------------+
utf8mb4_bin
+--------------------------------------------+
1 row in set (0.00 sec)