oceanbase

1
show collation;
2
Collation	Charset	Id	Default	Compiled	Sortlen
3
utf8mb4_general_ci	utf8mb4	45	Yes	Yes	1
4
utf8mb4_bin	utf8mb4	46		Yes	1
5
binary	binary	63	Yes	Yes	1
6
gbk_chinese_ci	gbk	28	Yes	Yes	1
7
gbk_bin	gbk	87		Yes	1
8
utf16_general_ci	utf16	54	Yes	Yes	1
9
utf16_bin	utf16	55		Yes	1
10
utf8mb4_unicode_ci	utf8mb4	224		Yes	1
11
utf16_unicode_ci	utf16	101		Yes	1
12
gb18030_chinese_ci	gb18030	248	Yes	Yes	1
13
gb18030_bin	gb18030	249		Yes	1
14
latin1_swedish_ci	latin1	8	Yes	Yes	1
15
latin1_bin	latin1	47		Yes	1
16
gb18030_2022_bin	gb18030_2022	216		Yes	1
17
gb18030_2022_chinese_ci	gb18030_2022	217	Yes	Yes	1
18
gb18030_2022_chinese_cs	gb18030_2022	218		Yes	1
19
gb18030_2022_radical_ci	gb18030_2022	219		Yes	1
20
gb18030_2022_radical_cs	gb18030_2022	220		Yes	1
21
gb18030_2022_stroke_ci	gb18030_2022	221		Yes	1
22
gb18030_2022_stroke_cs	gb18030_2022	222		Yes	1
23
show collation;
24
Collation	Charset	Id	Default	Compiled	Sortlen
25
utf8mb4_general_ci	utf8mb4	45	Yes	Yes	1
26
utf8mb4_bin	utf8mb4	46		Yes	1
27
binary	binary	63	Yes	Yes	1
28
gbk_chinese_ci	gbk	28	Yes	Yes	1
29
gbk_bin	gbk	87		Yes	1
30
utf16_general_ci	utf16	54	Yes	Yes	1
31
utf16_bin	utf16	55		Yes	1
32
utf8mb4_unicode_ci	utf8mb4	224		Yes	1
33
utf16_unicode_ci	utf16	101		Yes	1
34
gb18030_chinese_ci	gb18030	248	Yes	Yes	1
35
gb18030_bin	gb18030	249		Yes	1
36
latin1_swedish_ci	latin1	8	Yes	Yes	1
37
latin1_bin	latin1	47		Yes	1
38
gb18030_2022_bin	gb18030_2022	216		Yes	1
39
gb18030_2022_chinese_ci	gb18030_2022	217	Yes	Yes	1
40
gb18030_2022_chinese_cs	gb18030_2022	218		Yes	1
41
gb18030_2022_radical_ci	gb18030_2022	219		Yes	1
42
gb18030_2022_radical_cs	gb18030_2022	220		Yes	1
43
gb18030_2022_stroke_ci	gb18030_2022	221		Yes	1
44
gb18030_2022_stroke_cs	gb18030_2022	222		Yes	1
45
show collation test;
46
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'test' at line 1
47
SHOW CHARACTER SET;
48
Charset	Description	Default collation	Maxlen
49
binary	Binary pseudo charset	binary	1
50
utf8mb4	UTF-8 Unicode	utf8mb4_general_ci	4
51
gbk	GBK charset	gbk_chinese_ci	2
52
utf16	UTF-16 Unicode	utf16_general_ci	2
53
gb18030	GB18030 charset	gb18030_chinese_ci	4
54
latin1	cp1252 West European	latin1_swedish_ci	1
55
gb18030_2022	GB18030-2022 charset	gb18030_2022_chinese_ci	4
56
SHOW CHARACTER SET;
57
Charset	Description	Default collation	Maxlen
58
binary	Binary pseudo charset	binary	1
59
utf8mb4	UTF-8 Unicode	utf8mb4_general_ci	4
60
gbk	GBK charset	gbk_chinese_ci	2
61
utf16	UTF-16 Unicode	utf16_general_ci	2
62
gb18030	GB18030 charset	gb18030_chinese_ci	4
63
latin1	cp1252 West European	latin1_swedish_ci	1
64
gb18030_2022	GB18030-2022 charset	gb18030_2022_chinese_ci	4
65
SHOW CHARACTER SET test;
66
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'test' at line 1
67
set names utf8;
68
set names utf8;
69
set names;
70
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'names' at line 1
71
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
72
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
73
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED test;
74
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'test' at line 1
75
show girls;
76
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'girls' at line 1
77
show   girls;
78
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'girls' at line 1
79
show girls test;
80
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'girls test' at line 1
81