show collation; Collation Charset Id Default Compiled Sortlen utf8mb4_general_ci utf8mb4 45 Yes Yes 1 utf8mb4_bin utf8mb4 46 Yes 1 binary binary 63 Yes Yes 1 gbk_chinese_ci gbk 28 Yes Yes 1 gbk_bin gbk 87 Yes 1 utf16_general_ci utf16 54 Yes Yes 1 utf16_bin utf16 55 Yes 1 gb18030_chinese_ci gb18030 248 Yes Yes 2 gb18030_bin gb18030 249 Yes 1 latin1_swedish_ci latin1 8 Yes Yes 1 latin1_german1_ci latin1 5 Yes 1 latin1_danish_ci latin1 15 Yes 1 latin1_german2_ci latin1 31 Yes 1 latin1_general_ci latin1 48 Yes 1 latin1_general_cs latin1 49 Yes 1 latin1_spanish_ci latin1 94 Yes 1 latin1_bin latin1 47 Yes 1 gb18030_2022_bin gb18030_2022 216 Yes 1 gb18030_2022_chinese_ci gb18030_2022 217 Yes Yes 1 gb18030_2022_chinese_cs gb18030_2022 218 Yes 1 gb18030_2022_radical_ci gb18030_2022 219 Yes 1 gb18030_2022_radical_cs gb18030_2022 220 Yes 1 gb18030_2022_stroke_ci gb18030_2022 221 Yes 1 gb18030_2022_stroke_cs gb18030_2022 222 Yes 1 ascii_general_ci ascii 11 Yes Yes 1 ascii_bin ascii 65 Yes 1 tis620_thai_ci tis620 18 Yes Yes 1 tis620_bin tis620 89 Yes 1 utf16le_general_ci utf16le 56 Yes Yes 1 utf16le_bin utf16le 62 Yes 1 sjis_japanese_ci sjis 13 Yes Yes 1 sjis_bin sjis 88 Yes 1 big5_chinese_ci big5 1 Yes Yes 1 big5_bin big5 84 Yes 1 hkscs_bin hkscs 152 Yes Yes 1 hkscs31_bin hkscs31 153 Yes Yes 1 utf16_unicode_ci utf16 101 Yes 8 utf16_icelandic_ci utf16 102 Yes 8 utf16_latvian_ci utf16 103 Yes 8 utf16_romanian_ci utf16 104 Yes 8 utf16_slovenian_ci utf16 105 Yes 8 utf16_polish_ci utf16 106 Yes 8 utf16_estonian_ci utf16 107 Yes 8 utf16_spanish_ci utf16 108 Yes 8 utf16_swedish_ci utf16 109 Yes 8 utf16_turkish_ci utf16 110 Yes 8 utf16_czech_ci utf16 111 Yes 8 utf16_danish_ci utf16 112 Yes 8 utf16_lithuanian_ci utf16 113 Yes 8 utf16_slovak_ci utf16 114 Yes 8 utf16_spanish2_ci utf16 115 Yes 8 utf16_roman_ci utf16 116 Yes 8 utf16_persian_ci utf16 117 Yes 8 utf16_esperanto_ci utf16 118 Yes 8 utf16_hungarian_ci utf16 119 Yes 8 utf16_sinhala_ci utf16 120 Yes 8 utf16_german2_ci utf16 121 Yes 8 utf16_croatian_ci utf16 122 Yes 8 utf16_unicode_520_ci utf16 123 Yes 8 utf16_vietnamese_ci utf16 124 Yes 8 utf8mb4_unicode_ci utf8mb4 224 Yes 8 utf8mb4_icelandic_ci utf8mb4 225 Yes 8 utf8mb4_latvian_ci utf8mb4 226 Yes 8 utf8mb4_romanian_ci utf8mb4 227 Yes 8 utf8mb4_slovenian_ci utf8mb4 228 Yes 8 utf8mb4_polish_ci utf8mb4 229 Yes 8 utf8mb4_estonian_ci utf8mb4 230 Yes 8 utf8mb4_spanish_ci utf8mb4 231 Yes 8 utf8mb4_swedish_ci utf8mb4 232 Yes 8 utf8mb4_turkish_ci utf8mb4 233 Yes 8 utf8mb4_czech_ci utf8mb4 234 Yes 8 utf8mb4_danish_ci utf8mb4 235 Yes 8 utf8mb4_lithuanian_ci utf8mb4 236 Yes 8 utf8mb4_slovak_ci utf8mb4 237 Yes 8 utf8mb4_spanish2_ci utf8mb4 238 Yes 8 utf8mb4_roman_ci utf8mb4 239 Yes 8 utf8mb4_persian_ci utf8mb4 240 Yes 8 utf8mb4_esperanto_ci utf8mb4 241 Yes 8 utf8mb4_hungarian_ci utf8mb4 242 Yes 8 utf8mb4_sinhala_ci utf8mb4 243 Yes 8 utf8mb4_german2_ci utf8mb4 244 Yes 8 utf8mb4_croatian_ci utf8mb4 245 Yes 8 utf8mb4_unicode_520_ci utf8mb4 246 Yes 8 utf8mb4_vietnamese_ci utf8mb4 247 Yes 8 dec8_swedish_ci dec8 3 Yes Yes 8 dec8_bin dec8 69 Yes 8 utf8mb4_0900_ai_ci utf8mb4 255 Yes 0 utf8mb4_de_pb_0900_ai_ci utf8mb4 256 Yes 0 utf8mb4_is_0900_ai_ci utf8mb4 257 Yes 0 utf8mb4_lv_0900_ai_ci utf8mb4 258 Yes 0 utf8mb4_ro_0900_ai_ci utf8mb4 259 Yes 0 utf8mb4_sl_0900_ai_ci utf8mb4 260 Yes 0 utf8mb4_pl_0900_ai_ci utf8mb4 261 Yes 0 utf8mb4_et_0900_ai_ci utf8mb4 262 Yes 0 utf8mb4_es_0900_ai_ci utf8mb4 263 Yes 0 utf8mb4_sv_0900_ai_ci utf8mb4 264 Yes 0 utf8mb4_tr_0900_ai_ci utf8mb4 265 Yes 0 utf8mb4_cs_0900_ai_ci utf8mb4 266 Yes 0 utf8mb4_da_0900_ai_ci utf8mb4 267 Yes 0 utf8mb4_lt_0900_ai_ci utf8mb4 268 Yes 0 utf8mb4_sk_0900_ai_ci utf8mb4 269 Yes 0 utf8mb4_es_trad_0900_ai_ci utf8mb4 270 Yes 0 utf8mb4_la_0900_ai_ci utf8mb4 271 Yes 0 utf8mb4_eo_0900_ai_ci utf8mb4 273 Yes 0 utf8mb4_hu_0900_ai_ci utf8mb4 274 Yes 0 utf8mb4_hr_0900_ai_ci utf8mb4 275 Yes 0 utf8mb4_vi_0900_ai_ci utf8mb4 277 Yes 0 utf8mb4_0900_as_cs utf8mb4 278 Yes 0 utf8mb4_de_pb_0900_as_cs utf8mb4 279 Yes 0 utf8mb4_is_0900_as_cs utf8mb4 280 Yes 0 utf8mb4_lv_0900_as_cs utf8mb4 281 Yes 0 utf8mb4_ro_0900_as_cs utf8mb4 282 Yes 0 utf8mb4_sl_0900_as_cs utf8mb4 283 Yes 0 utf8mb4_pl_0900_as_cs utf8mb4 284 Yes 0 utf8mb4_et_0900_as_cs utf8mb4 285 Yes 0 utf8mb4_es_0900_as_cs utf8mb4 286 Yes 0 utf8mb4_sv_0900_as_cs utf8mb4 287 Yes 0 utf8mb4_tr_0900_as_cs utf8mb4 288 Yes 0 utf8mb4_cs_0900_as_cs utf8mb4 289 Yes 0 utf8mb4_da_0900_as_cs utf8mb4 290 Yes 0 utf8mb4_lt_0900_as_cs utf8mb4 291 Yes 0 utf8mb4_sk_0900_as_cs utf8mb4 292 Yes 0 utf8mb4_es_trad_0900_as_cs utf8mb4 293 Yes 0 utf8mb4_la_0900_as_cs utf8mb4 294 Yes 0 utf8mb4_eo_0900_as_cs utf8mb4 296 Yes 0 utf8mb4_hu_0900_as_cs utf8mb4 297 Yes 0 utf8mb4_hr_0900_as_cs utf8mb4 298 Yes 0 utf8mb4_vi_0900_as_cs utf8mb4 300 Yes 0 utf8mb4_ja_0900_as_cs utf8mb4 303 Yes 0 utf8mb4_ja_0900_as_cs_ks utf8mb4 304 Yes 24 utf8mb4_0900_as_ci utf8mb4 305 Yes 0 utf8mb4_ru_0900_ai_ci utf8mb4 306 Yes 0 utf8mb4_ru_0900_as_cs utf8mb4 307 Yes 0 utf8mb4_zh_0900_as_cs utf8mb4 308 Yes 0 utf8mb4_0900_bin utf8mb4 309 Yes 1 utf8mb4_nb_0900_ai_ci utf8mb4 310 Yes 0 utf8mb4_nb_0900_as_cs utf8mb4 311 Yes 0 utf8mb4_nn_0900_ai_ci utf8mb4 312 Yes 0 utf8mb4_nn_0900_as_cs utf8mb4 313 Yes 0 utf8mb4_sr_latn_0900_ai_ci utf8mb4 314 Yes 0 utf8mb4_sr_latn_0900_as_cs utf8mb4 315 Yes 0 utf8mb4_bs_0900_ai_ci utf8mb4 316 Yes 0 utf8mb4_bs_0900_as_cs utf8mb4 317 Yes 0 utf8mb4_bg_0900_ai_ci utf8mb4 318 Yes 0 utf8mb4_bg_0900_as_cs utf8mb4 319 Yes 0 utf8mb4_gl_0900_ai_ci utf8mb4 320 Yes 0 utf8mb4_gl_0900_as_cs utf8mb4 321 Yes 0 utf8mb4_mn_cyrl_0900_ai_ci utf8mb4 322 Yes 0 utf8mb4_mn_cyrl_0900_as_cs utf8mb4 323 Yes 0 show collation; Collation Charset Id Default Compiled Sortlen utf8mb4_general_ci utf8mb4 45 Yes Yes 1 utf8mb4_bin utf8mb4 46 Yes 1 binary binary 63 Yes Yes 1 gbk_chinese_ci gbk 28 Yes Yes 1 gbk_bin gbk 87 Yes 1 utf16_general_ci utf16 54 Yes Yes 1 utf16_bin utf16 55 Yes 1 gb18030_chinese_ci gb18030 248 Yes Yes 2 gb18030_bin gb18030 249 Yes 1 latin1_swedish_ci latin1 8 Yes Yes 1 latin1_german1_ci latin1 5 Yes 1 latin1_danish_ci latin1 15 Yes 1 latin1_german2_ci latin1 31 Yes 1 latin1_general_ci latin1 48 Yes 1 latin1_general_cs latin1 49 Yes 1 latin1_spanish_ci latin1 94 Yes 1 latin1_bin latin1 47 Yes 1 gb18030_2022_bin gb18030_2022 216 Yes 1 gb18030_2022_chinese_ci gb18030_2022 217 Yes Yes 1 gb18030_2022_chinese_cs gb18030_2022 218 Yes 1 gb18030_2022_radical_ci gb18030_2022 219 Yes 1 gb18030_2022_radical_cs gb18030_2022 220 Yes 1 gb18030_2022_stroke_ci gb18030_2022 221 Yes 1 gb18030_2022_stroke_cs gb18030_2022 222 Yes 1 ascii_general_ci ascii 11 Yes Yes 1 ascii_bin ascii 65 Yes 1 tis620_thai_ci tis620 18 Yes Yes 1 tis620_bin tis620 89 Yes 1 utf16le_general_ci utf16le 56 Yes Yes 1 utf16le_bin utf16le 62 Yes 1 sjis_japanese_ci sjis 13 Yes Yes 1 sjis_bin sjis 88 Yes 1 big5_chinese_ci big5 1 Yes Yes 1 big5_bin big5 84 Yes 1 hkscs_bin hkscs 152 Yes Yes 1 hkscs31_bin hkscs31 153 Yes Yes 1 utf16_unicode_ci utf16 101 Yes 8 utf16_icelandic_ci utf16 102 Yes 8 utf16_latvian_ci utf16 103 Yes 8 utf16_romanian_ci utf16 104 Yes 8 utf16_slovenian_ci utf16 105 Yes 8 utf16_polish_ci utf16 106 Yes 8 utf16_estonian_ci utf16 107 Yes 8 utf16_spanish_ci utf16 108 Yes 8 utf16_swedish_ci utf16 109 Yes 8 utf16_turkish_ci utf16 110 Yes 8 utf16_czech_ci utf16 111 Yes 8 utf16_danish_ci utf16 112 Yes 8 utf16_lithuanian_ci utf16 113 Yes 8 utf16_slovak_ci utf16 114 Yes 8 utf16_spanish2_ci utf16 115 Yes 8 utf16_roman_ci utf16 116 Yes 8 utf16_persian_ci utf16 117 Yes 8 utf16_esperanto_ci utf16 118 Yes 8 utf16_hungarian_ci utf16 119 Yes 8 utf16_sinhala_ci utf16 120 Yes 8 utf16_german2_ci utf16 121 Yes 8 utf16_croatian_ci utf16 122 Yes 8 utf16_unicode_520_ci utf16 123 Yes 8 utf16_vietnamese_ci utf16 124 Yes 8 utf8mb4_unicode_ci utf8mb4 224 Yes 8 utf8mb4_icelandic_ci utf8mb4 225 Yes 8 utf8mb4_latvian_ci utf8mb4 226 Yes 8 utf8mb4_romanian_ci utf8mb4 227 Yes 8 utf8mb4_slovenian_ci utf8mb4 228 Yes 8 utf8mb4_polish_ci utf8mb4 229 Yes 8 utf8mb4_estonian_ci utf8mb4 230 Yes 8 utf8mb4_spanish_ci utf8mb4 231 Yes 8 utf8mb4_swedish_ci utf8mb4 232 Yes 8 utf8mb4_turkish_ci utf8mb4 233 Yes 8 utf8mb4_czech_ci utf8mb4 234 Yes 8 utf8mb4_danish_ci utf8mb4 235 Yes 8 utf8mb4_lithuanian_ci utf8mb4 236 Yes 8 utf8mb4_slovak_ci utf8mb4 237 Yes 8 utf8mb4_spanish2_ci utf8mb4 238 Yes 8 utf8mb4_roman_ci utf8mb4 239 Yes 8 utf8mb4_persian_ci utf8mb4 240 Yes 8 utf8mb4_esperanto_ci utf8mb4 241 Yes 8 utf8mb4_hungarian_ci utf8mb4 242 Yes 8 utf8mb4_sinhala_ci utf8mb4 243 Yes 8 utf8mb4_german2_ci utf8mb4 244 Yes 8 utf8mb4_croatian_ci utf8mb4 245 Yes 8 utf8mb4_unicode_520_ci utf8mb4 246 Yes 8 utf8mb4_vietnamese_ci utf8mb4 247 Yes 8 dec8_swedish_ci dec8 3 Yes Yes 8 dec8_bin dec8 69 Yes 8 utf8mb4_0900_ai_ci utf8mb4 255 Yes 0 utf8mb4_de_pb_0900_ai_ci utf8mb4 256 Yes 0 utf8mb4_is_0900_ai_ci utf8mb4 257 Yes 0 utf8mb4_lv_0900_ai_ci utf8mb4 258 Yes 0 utf8mb4_ro_0900_ai_ci utf8mb4 259 Yes 0 utf8mb4_sl_0900_ai_ci utf8mb4 260 Yes 0 utf8mb4_pl_0900_ai_ci utf8mb4 261 Yes 0 utf8mb4_et_0900_ai_ci utf8mb4 262 Yes 0 utf8mb4_es_0900_ai_ci utf8mb4 263 Yes 0 utf8mb4_sv_0900_ai_ci utf8mb4 264 Yes 0 utf8mb4_tr_0900_ai_ci utf8mb4 265 Yes 0 utf8mb4_cs_0900_ai_ci utf8mb4 266 Yes 0 utf8mb4_da_0900_ai_ci utf8mb4 267 Yes 0 utf8mb4_lt_0900_ai_ci utf8mb4 268 Yes 0 utf8mb4_sk_0900_ai_ci utf8mb4 269 Yes 0 utf8mb4_es_trad_0900_ai_ci utf8mb4 270 Yes 0 utf8mb4_la_0900_ai_ci utf8mb4 271 Yes 0 utf8mb4_eo_0900_ai_ci utf8mb4 273 Yes 0 utf8mb4_hu_0900_ai_ci utf8mb4 274 Yes 0 utf8mb4_hr_0900_ai_ci utf8mb4 275 Yes 0 utf8mb4_vi_0900_ai_ci utf8mb4 277 Yes 0 utf8mb4_0900_as_cs utf8mb4 278 Yes 0 utf8mb4_de_pb_0900_as_cs utf8mb4 279 Yes 0 utf8mb4_is_0900_as_cs utf8mb4 280 Yes 0 utf8mb4_lv_0900_as_cs utf8mb4 281 Yes 0 utf8mb4_ro_0900_as_cs utf8mb4 282 Yes 0 utf8mb4_sl_0900_as_cs utf8mb4 283 Yes 0 utf8mb4_pl_0900_as_cs utf8mb4 284 Yes 0 utf8mb4_et_0900_as_cs utf8mb4 285 Yes 0 utf8mb4_es_0900_as_cs utf8mb4 286 Yes 0 utf8mb4_sv_0900_as_cs utf8mb4 287 Yes 0 utf8mb4_tr_0900_as_cs utf8mb4 288 Yes 0 utf8mb4_cs_0900_as_cs utf8mb4 289 Yes 0 utf8mb4_da_0900_as_cs utf8mb4 290 Yes 0 utf8mb4_lt_0900_as_cs utf8mb4 291 Yes 0 utf8mb4_sk_0900_as_cs utf8mb4 292 Yes 0 utf8mb4_es_trad_0900_as_cs utf8mb4 293 Yes 0 utf8mb4_la_0900_as_cs utf8mb4 294 Yes 0 utf8mb4_eo_0900_as_cs utf8mb4 296 Yes 0 utf8mb4_hu_0900_as_cs utf8mb4 297 Yes 0 utf8mb4_hr_0900_as_cs utf8mb4 298 Yes 0 utf8mb4_vi_0900_as_cs utf8mb4 300 Yes 0 utf8mb4_ja_0900_as_cs utf8mb4 303 Yes 0 utf8mb4_ja_0900_as_cs_ks utf8mb4 304 Yes 24 utf8mb4_0900_as_ci utf8mb4 305 Yes 0 utf8mb4_ru_0900_ai_ci utf8mb4 306 Yes 0 utf8mb4_ru_0900_as_cs utf8mb4 307 Yes 0 utf8mb4_zh_0900_as_cs utf8mb4 308 Yes 0 utf8mb4_0900_bin utf8mb4 309 Yes 1 utf8mb4_nb_0900_ai_ci utf8mb4 310 Yes 0 utf8mb4_nb_0900_as_cs utf8mb4 311 Yes 0 utf8mb4_nn_0900_ai_ci utf8mb4 312 Yes 0 utf8mb4_nn_0900_as_cs utf8mb4 313 Yes 0 utf8mb4_sr_latn_0900_ai_ci utf8mb4 314 Yes 0 utf8mb4_sr_latn_0900_as_cs utf8mb4 315 Yes 0 utf8mb4_bs_0900_ai_ci utf8mb4 316 Yes 0 utf8mb4_bs_0900_as_cs utf8mb4 317 Yes 0 utf8mb4_bg_0900_ai_ci utf8mb4 318 Yes 0 utf8mb4_bg_0900_as_cs utf8mb4 319 Yes 0 utf8mb4_gl_0900_ai_ci utf8mb4 320 Yes 0 utf8mb4_gl_0900_as_cs utf8mb4 321 Yes 0 utf8mb4_mn_cyrl_0900_ai_ci utf8mb4 322 Yes 0 utf8mb4_mn_cyrl_0900_as_cs utf8mb4 323 Yes 0 show collation test; 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 SHOW CHARACTER SET; Charset Description Default collation Maxlen binary Binary pseudo charset binary 1 utf8mb4 UTF-8 Unicode utf8mb4_general_ci 4 gbk GBK charset gbk_chinese_ci 2 utf16 UTF-16 Unicode utf16_general_ci 4 gb18030 GB18030 charset gb18030_chinese_ci 4 latin1 cp1252 West European latin1_swedish_ci 1 gb18030_2022 GB18030-2022 charset gb18030_2022_chinese_ci 4 ascii US ASCII ascii_general_ci 1 tis620 TIS620 Thai tis620_thai_ci 1 utf16le UTF-16LE Unicode utf16le_general_ci 4 sjis SJIS sjis_japanese_ci 2 big5 BIG5 big5_chinese_ci 2 hkscs HKSCS hkscs_bin 2 hkscs31 HKSCS-ISO UNICODE 31 hkscs31_bin 2 dec8 DEC West European dec8_swedish_ci 1 SHOW CHARACTER SET; Charset Description Default collation Maxlen binary Binary pseudo charset binary 1 utf8mb4 UTF-8 Unicode utf8mb4_general_ci 4 gbk GBK charset gbk_chinese_ci 2 utf16 UTF-16 Unicode utf16_general_ci 4 gb18030 GB18030 charset gb18030_chinese_ci 4 latin1 cp1252 West European latin1_swedish_ci 1 gb18030_2022 GB18030-2022 charset gb18030_2022_chinese_ci 4 ascii US ASCII ascii_general_ci 1 tis620 TIS620 Thai tis620_thai_ci 1 utf16le UTF-16LE Unicode utf16le_general_ci 4 sjis SJIS sjis_japanese_ci 2 big5 BIG5 big5_chinese_ci 2 hkscs HKSCS hkscs_bin 2 hkscs31 HKSCS-ISO UNICODE 31 hkscs31_bin 2 dec8 DEC West European dec8_swedish_ci 1 SHOW CHARACTER SET test; 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 set names utf8; set names utf8; set names; 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 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED test; 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 show girls; 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 show girls; 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 show girls test; 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