Files
greptimedb/tests/cases/standalone/common/show/show_collation.result
dennis zhuang 8f2ce4abe8 feat: impl show collation and show charset statements (#3753)
* feat: impl show collation and show charset statements

* docs: add api docs
2024-04-20 06:01:32 +00:00

32 lines
782 B
Plaintext

SHOW COLLATION;
+-----------+---------+----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+-----------+---------+----+---------+----------+---------+
| utf8_bin | utf8 | 1 | Yes | Yes | 1 |
+-----------+---------+----+---------+----------+---------+
SHOW COLLATION LIKE 'utf8';
++
++
SHOW COLLATION WHERE Charset = 'utf8';
+-----------+---------+----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+-----------+---------+----+---------+----------+---------+
| utf8_bin | utf8 | 1 | Yes | Yes | 1 |
+-----------+---------+----+---------+----------+---------+
SHOW COLLATION WHERE Charset = 'latin1';
++
++
SHOW COLLATION LIKE 'latin1';
++
++