oceanbase

1
select @@version_comment limit 1;
2
@@version_comment
3
ob_version_info
4
SELECT @@session.auto_increment_increment;
5
@@session.auto_increment_increment
6
1
7
SHOW COLLATION;
8
Collation	Charset	Id	Default	Compiled	Sortlen
9
utf8mb4_general_ci	utf8mb4	45	Yes	Yes	1
10
utf8mb4_bin	utf8mb4	46		Yes	1
11
binary	binary	63	Yes	Yes	1
12
gbk_chinese_ci	gbk	28	Yes	Yes	1
13
gbk_bin	gbk	87		Yes	1
14
utf16_general_ci	utf16	54	Yes	Yes	1
15
utf16_bin	utf16	55		Yes	1
16
utf8mb4_unicode_ci	utf8mb4	224		Yes	1
17
utf16_unicode_ci	utf16	101		Yes	1
18
gb18030_chinese_ci	gb18030	248	Yes	Yes	1
19
gb18030_bin	gb18030	249		Yes	1
20
latin1_swedish_ci	latin1	8	Yes	Yes	1
21
latin1_bin	latin1	47		Yes	1
22
gb18030_2022_bin	gb18030_2022	216		Yes	1
23
gb18030_2022_chinese_ci	gb18030_2022	217	Yes	Yes	1
24
gb18030_2022_chinese_cs	gb18030_2022	218		Yes	1
25
gb18030_2022_radical_ci	gb18030_2022	219		Yes	1
26
gb18030_2022_radical_cs	gb18030_2022	220		Yes	1
27
gb18030_2022_stroke_ci	gb18030_2022	221		Yes	1
28
gb18030_2022_stroke_cs	gb18030_2022	222		Yes	1
29
SHOW CHARACTER SET;
30
Charset	Description	Default collation	Maxlen
31
binary	Binary pseudo charset	binary	1
32
utf8mb4	UTF-8 Unicode	utf8mb4_general_ci	4
33
gbk	GBK charset	gbk_chinese_ci	2
34
utf16	UTF-16 Unicode	utf16_general_ci	2
35
gb18030	GB18030 charset	gb18030_chinese_ci	4
36
latin1	cp1252 West European	latin1_swedish_ci	1
37
gb18030_2022	GB18030-2022 charset	gb18030_2022_chinese_ci	4
38
SET NAMES latin1;
39