mirror of
https://github.com/MariaDB/server.git
synced 2025-09-11 05:52:26 +03:00
2318 lines
108 KiB
Plaintext
2318 lines
108 KiB
Plaintext
DROP DATABASE IF EXISTS d10;
|
|
SHOW COLLATION;
|
|
Collation Charset Id Default Compiled Sortlen
|
|
big5_chinese_ci big5 1 Yes # #
|
|
big5_bin big5 84 # #
|
|
big5_chinese_nopad_ci big5 1025 # #
|
|
big5_nopad_bin big5 1108 # #
|
|
dec8_swedish_ci dec8 3 Yes # #
|
|
dec8_bin dec8 69 # #
|
|
dec8_swedish_nopad_ci dec8 1027 # #
|
|
dec8_nopad_bin dec8 1093 # #
|
|
cp850_general_ci cp850 4 Yes # #
|
|
cp850_bin cp850 80 # #
|
|
cp850_general_nopad_ci cp850 1028 # #
|
|
cp850_nopad_bin cp850 1104 # #
|
|
hp8_english_ci hp8 6 Yes # #
|
|
hp8_bin hp8 72 # #
|
|
hp8_english_nopad_ci hp8 1030 # #
|
|
hp8_nopad_bin hp8 1096 # #
|
|
koi8r_general_ci koi8r 7 Yes # #
|
|
koi8r_bin koi8r 74 # #
|
|
koi8r_general_nopad_ci koi8r 1031 # #
|
|
koi8r_nopad_bin koi8r 1098 # #
|
|
latin1_german1_ci latin1 5 # #
|
|
latin1_swedish_ci latin1 8 Yes # #
|
|
latin1_danish_ci latin1 15 # #
|
|
latin1_german2_ci latin1 31 # #
|
|
latin1_bin latin1 47 # #
|
|
latin1_general_ci latin1 48 # #
|
|
latin1_general_cs latin1 49 # #
|
|
latin1_spanish_ci latin1 94 # #
|
|
latin1_swedish_nopad_ci latin1 1032 # #
|
|
latin1_nopad_bin latin1 1071 # #
|
|
latin2_czech_cs latin2 2 # #
|
|
latin2_general_ci latin2 9 Yes # #
|
|
latin2_hungarian_ci latin2 21 # #
|
|
latin2_croatian_ci latin2 27 # #
|
|
latin2_bin latin2 77 # #
|
|
latin2_general_nopad_ci latin2 1033 # #
|
|
latin2_nopad_bin latin2 1101 # #
|
|
swe7_swedish_ci swe7 10 Yes # #
|
|
swe7_bin swe7 82 # #
|
|
swe7_swedish_nopad_ci swe7 1034 # #
|
|
swe7_nopad_bin swe7 1106 # #
|
|
ascii_general_ci ascii 11 Yes # #
|
|
ascii_bin ascii 65 # #
|
|
ascii_general_nopad_ci ascii 1035 # #
|
|
ascii_nopad_bin ascii 1089 # #
|
|
ujis_japanese_ci ujis 12 Yes # #
|
|
ujis_bin ujis 91 # #
|
|
ujis_japanese_nopad_ci ujis 1036 # #
|
|
ujis_nopad_bin ujis 1115 # #
|
|
sjis_japanese_ci sjis 13 Yes # #
|
|
sjis_bin sjis 88 # #
|
|
sjis_japanese_nopad_ci sjis 1037 # #
|
|
sjis_nopad_bin sjis 1112 # #
|
|
hebrew_general_ci hebrew 16 Yes # #
|
|
hebrew_bin hebrew 71 # #
|
|
hebrew_general_nopad_ci hebrew 1040 # #
|
|
hebrew_nopad_bin hebrew 1095 # #
|
|
tis620_thai_ci tis620 18 Yes # #
|
|
tis620_bin tis620 89 # #
|
|
tis620_thai_nopad_ci tis620 1042 # #
|
|
tis620_nopad_bin tis620 1113 # #
|
|
euckr_korean_ci euckr 19 Yes # #
|
|
euckr_bin euckr 85 # #
|
|
euckr_korean_nopad_ci euckr 1043 # #
|
|
euckr_nopad_bin euckr 1109 # #
|
|
koi8u_general_ci koi8u 22 Yes # #
|
|
koi8u_bin koi8u 75 # #
|
|
koi8u_general_nopad_ci koi8u 1046 # #
|
|
koi8u_nopad_bin koi8u 1099 # #
|
|
gb2312_chinese_ci gb2312 24 Yes # #
|
|
gb2312_bin gb2312 86 # #
|
|
gb2312_chinese_nopad_ci gb2312 1048 # #
|
|
gb2312_nopad_bin gb2312 1110 # #
|
|
greek_general_ci greek 25 Yes # #
|
|
greek_bin greek 70 # #
|
|
greek_general_nopad_ci greek 1049 # #
|
|
greek_nopad_bin greek 1094 # #
|
|
cp1250_general_ci cp1250 26 Yes # #
|
|
cp1250_czech_cs cp1250 34 # #
|
|
cp1250_croatian_ci cp1250 44 # #
|
|
cp1250_bin cp1250 66 # #
|
|
cp1250_polish_ci cp1250 99 # #
|
|
cp1250_general_nopad_ci cp1250 1050 # #
|
|
cp1250_nopad_bin cp1250 1090 # #
|
|
gbk_chinese_ci gbk 28 Yes # #
|
|
gbk_bin gbk 87 # #
|
|
gbk_chinese_nopad_ci gbk 1052 # #
|
|
gbk_nopad_bin gbk 1111 # #
|
|
latin5_turkish_ci latin5 30 Yes # #
|
|
latin5_bin latin5 78 # #
|
|
latin5_turkish_nopad_ci latin5 1054 # #
|
|
latin5_nopad_bin latin5 1102 # #
|
|
armscii8_general_ci armscii8 32 Yes # #
|
|
armscii8_bin armscii8 64 # #
|
|
armscii8_general_nopad_ci armscii8 1056 # #
|
|
armscii8_nopad_bin armscii8 1088 # #
|
|
utf8mb3_general_ci utf8mb3 33 Yes # #
|
|
utf8mb3_bin utf8mb3 83 # #
|
|
utf8mb3_unicode_ci utf8mb3 192 # #
|
|
utf8mb3_icelandic_ci utf8mb3 193 # #
|
|
utf8mb3_latvian_ci utf8mb3 194 # #
|
|
utf8mb3_romanian_ci utf8mb3 195 # #
|
|
utf8mb3_slovenian_ci utf8mb3 196 # #
|
|
utf8mb3_polish_ci utf8mb3 197 # #
|
|
utf8mb3_estonian_ci utf8mb3 198 # #
|
|
utf8mb3_spanish_ci utf8mb3 199 # #
|
|
utf8mb3_swedish_ci utf8mb3 200 # #
|
|
utf8mb3_turkish_ci utf8mb3 201 # #
|
|
utf8mb3_czech_ci utf8mb3 202 # #
|
|
utf8mb3_danish_ci utf8mb3 203 # #
|
|
utf8mb3_lithuanian_ci utf8mb3 204 # #
|
|
utf8mb3_slovak_ci utf8mb3 205 # #
|
|
utf8mb3_spanish2_ci utf8mb3 206 # #
|
|
utf8mb3_roman_ci utf8mb3 207 # #
|
|
utf8mb3_persian_ci utf8mb3 208 # #
|
|
utf8mb3_esperanto_ci utf8mb3 209 # #
|
|
utf8mb3_hungarian_ci utf8mb3 210 # #
|
|
utf8mb3_sinhala_ci utf8mb3 211 # #
|
|
utf8mb3_german2_ci utf8mb3 212 # #
|
|
utf8mb3_croatian_mysql561_ci utf8mb3 213 # #
|
|
utf8mb3_unicode_520_ci utf8mb3 214 # #
|
|
utf8mb3_vietnamese_ci utf8mb3 215 # #
|
|
utf8mb3_general_mysql500_ci utf8mb3 223 # #
|
|
utf8mb3_croatian_ci utf8mb3 576 # #
|
|
utf8mb3_myanmar_ci utf8mb3 577 # #
|
|
utf8mb3_thai_520_w2 utf8mb3 578 # #
|
|
utf8mb3_general_nopad_ci utf8mb3 1057 # #
|
|
utf8mb3_nopad_bin utf8mb3 1107 # #
|
|
utf8mb3_unicode_nopad_ci utf8mb3 1216 # #
|
|
utf8mb3_unicode_520_nopad_ci utf8mb3 1238 # #
|
|
ucs2_general_ci ucs2 35 Yes # #
|
|
ucs2_bin ucs2 90 # #
|
|
ucs2_unicode_ci ucs2 128 # #
|
|
ucs2_icelandic_ci ucs2 129 # #
|
|
ucs2_latvian_ci ucs2 130 # #
|
|
ucs2_romanian_ci ucs2 131 # #
|
|
ucs2_slovenian_ci ucs2 132 # #
|
|
ucs2_polish_ci ucs2 133 # #
|
|
ucs2_estonian_ci ucs2 134 # #
|
|
ucs2_spanish_ci ucs2 135 # #
|
|
ucs2_swedish_ci ucs2 136 # #
|
|
ucs2_turkish_ci ucs2 137 # #
|
|
ucs2_czech_ci ucs2 138 # #
|
|
ucs2_danish_ci ucs2 139 # #
|
|
ucs2_lithuanian_ci ucs2 140 # #
|
|
ucs2_slovak_ci ucs2 141 # #
|
|
ucs2_spanish2_ci ucs2 142 # #
|
|
ucs2_roman_ci ucs2 143 # #
|
|
ucs2_persian_ci ucs2 144 # #
|
|
ucs2_esperanto_ci ucs2 145 # #
|
|
ucs2_hungarian_ci ucs2 146 # #
|
|
ucs2_sinhala_ci ucs2 147 # #
|
|
ucs2_german2_ci ucs2 148 # #
|
|
ucs2_croatian_mysql561_ci ucs2 149 # #
|
|
ucs2_unicode_520_ci ucs2 150 # #
|
|
ucs2_vietnamese_ci ucs2 151 # #
|
|
ucs2_general_mysql500_ci ucs2 159 # #
|
|
ucs2_croatian_ci ucs2 640 # #
|
|
ucs2_myanmar_ci ucs2 641 # #
|
|
ucs2_thai_520_w2 ucs2 642 # #
|
|
ucs2_general_nopad_ci ucs2 1059 # #
|
|
ucs2_nopad_bin ucs2 1114 # #
|
|
ucs2_unicode_nopad_ci ucs2 1152 # #
|
|
ucs2_unicode_520_nopad_ci ucs2 1174 # #
|
|
cp866_general_ci cp866 36 Yes # #
|
|
cp866_bin cp866 68 # #
|
|
cp866_general_nopad_ci cp866 1060 # #
|
|
cp866_nopad_bin cp866 1092 # #
|
|
keybcs2_general_ci keybcs2 37 Yes # #
|
|
keybcs2_bin keybcs2 73 # #
|
|
keybcs2_general_nopad_ci keybcs2 1061 # #
|
|
keybcs2_nopad_bin keybcs2 1097 # #
|
|
macce_general_ci macce 38 Yes # #
|
|
macce_bin macce 43 # #
|
|
macce_general_nopad_ci macce 1062 # #
|
|
macce_nopad_bin macce 1067 # #
|
|
macroman_general_ci macroman 39 Yes # #
|
|
macroman_bin macroman 53 # #
|
|
macroman_general_nopad_ci macroman 1063 # #
|
|
macroman_nopad_bin macroman 1077 # #
|
|
cp852_general_ci cp852 40 Yes # #
|
|
cp852_bin cp852 81 # #
|
|
cp852_general_nopad_ci cp852 1064 # #
|
|
cp852_nopad_bin cp852 1105 # #
|
|
latin7_estonian_cs latin7 20 # #
|
|
latin7_general_ci latin7 41 Yes # #
|
|
latin7_general_cs latin7 42 # #
|
|
latin7_bin latin7 79 # #
|
|
latin7_general_nopad_ci latin7 1065 # #
|
|
latin7_nopad_bin latin7 1103 # #
|
|
utf8mb4_general_ci utf8mb4 45 Yes # #
|
|
utf8mb4_bin utf8mb4 46 # #
|
|
utf8mb4_unicode_ci utf8mb4 224 # #
|
|
utf8mb4_icelandic_ci utf8mb4 225 # #
|
|
utf8mb4_latvian_ci utf8mb4 226 # #
|
|
utf8mb4_romanian_ci utf8mb4 227 # #
|
|
utf8mb4_slovenian_ci utf8mb4 228 # #
|
|
utf8mb4_polish_ci utf8mb4 229 # #
|
|
utf8mb4_estonian_ci utf8mb4 230 # #
|
|
utf8mb4_spanish_ci utf8mb4 231 # #
|
|
utf8mb4_swedish_ci utf8mb4 232 # #
|
|
utf8mb4_turkish_ci utf8mb4 233 # #
|
|
utf8mb4_czech_ci utf8mb4 234 # #
|
|
utf8mb4_danish_ci utf8mb4 235 # #
|
|
utf8mb4_lithuanian_ci utf8mb4 236 # #
|
|
utf8mb4_slovak_ci utf8mb4 237 # #
|
|
utf8mb4_spanish2_ci utf8mb4 238 # #
|
|
utf8mb4_roman_ci utf8mb4 239 # #
|
|
utf8mb4_persian_ci utf8mb4 240 # #
|
|
utf8mb4_esperanto_ci utf8mb4 241 # #
|
|
utf8mb4_hungarian_ci utf8mb4 242 # #
|
|
utf8mb4_sinhala_ci utf8mb4 243 # #
|
|
utf8mb4_german2_ci utf8mb4 244 # #
|
|
utf8mb4_croatian_mysql561_ci utf8mb4 245 # #
|
|
utf8mb4_unicode_520_ci utf8mb4 246 # #
|
|
utf8mb4_vietnamese_ci utf8mb4 247 # #
|
|
utf8mb4_0900_ai_ci utf8mb4 255 # #
|
|
utf8mb4_de_pb_0900_ai_ci utf8mb4 256 # #
|
|
utf8mb4_is_0900_ai_ci utf8mb4 257 # #
|
|
utf8mb4_lv_0900_ai_ci utf8mb4 258 # #
|
|
utf8mb4_ro_0900_ai_ci utf8mb4 259 # #
|
|
utf8mb4_sl_0900_ai_ci utf8mb4 260 # #
|
|
utf8mb4_pl_0900_ai_ci utf8mb4 261 # #
|
|
utf8mb4_et_0900_ai_ci utf8mb4 262 # #
|
|
utf8mb4_es_0900_ai_ci utf8mb4 263 # #
|
|
utf8mb4_sv_0900_ai_ci utf8mb4 264 # #
|
|
utf8mb4_tr_0900_ai_ci utf8mb4 265 # #
|
|
utf8mb4_cs_0900_ai_ci utf8mb4 266 # #
|
|
utf8mb4_da_0900_ai_ci utf8mb4 267 # #
|
|
utf8mb4_lt_0900_ai_ci utf8mb4 268 # #
|
|
utf8mb4_sk_0900_ai_ci utf8mb4 269 # #
|
|
utf8mb4_es_trad_0900_ai_ci utf8mb4 270 # #
|
|
utf8mb4_la_0900_ai_ci utf8mb4 271 # #
|
|
utf8mb4_eo_0900_ai_ci utf8mb4 273 # #
|
|
utf8mb4_hu_0900_ai_ci utf8mb4 274 # #
|
|
utf8mb4_hr_0900_ai_ci utf8mb4 275 # #
|
|
utf8mb4_vi_0900_ai_ci utf8mb4 277 # #
|
|
utf8mb4_0900_as_cs utf8mb4 278 # #
|
|
utf8mb4_de_pb_0900_as_cs utf8mb4 279 # #
|
|
utf8mb4_is_0900_as_cs utf8mb4 280 # #
|
|
utf8mb4_lv_0900_as_cs utf8mb4 281 # #
|
|
utf8mb4_ro_0900_as_cs utf8mb4 282 # #
|
|
utf8mb4_sl_0900_as_cs utf8mb4 283 # #
|
|
utf8mb4_pl_0900_as_cs utf8mb4 284 # #
|
|
utf8mb4_et_0900_as_cs utf8mb4 285 # #
|
|
utf8mb4_es_0900_as_cs utf8mb4 286 # #
|
|
utf8mb4_sv_0900_as_cs utf8mb4 287 # #
|
|
utf8mb4_tr_0900_as_cs utf8mb4 288 # #
|
|
utf8mb4_cs_0900_as_cs utf8mb4 289 # #
|
|
utf8mb4_da_0900_as_cs utf8mb4 290 # #
|
|
utf8mb4_lt_0900_as_cs utf8mb4 291 # #
|
|
utf8mb4_sk_0900_as_cs utf8mb4 292 # #
|
|
utf8mb4_es_trad_0900_as_cs utf8mb4 293 # #
|
|
utf8mb4_la_0900_as_cs utf8mb4 294 # #
|
|
utf8mb4_eo_0900_as_cs utf8mb4 296 # #
|
|
utf8mb4_hu_0900_as_cs utf8mb4 297 # #
|
|
utf8mb4_hr_0900_as_cs utf8mb4 298 # #
|
|
utf8mb4_vi_0900_as_cs utf8mb4 300 # #
|
|
utf8mb4_0900_as_ci utf8mb4 305 # #
|
|
utf8mb4_0900_bin utf8mb4 309 # #
|
|
utf8mb4_croatian_ci utf8mb4 608 # #
|
|
utf8mb4_myanmar_ci utf8mb4 609 # #
|
|
utf8mb4_thai_520_w2 utf8mb4 610 # #
|
|
utf8mb4_general_nopad_ci utf8mb4 1069 # #
|
|
utf8mb4_nopad_bin utf8mb4 1070 # #
|
|
utf8mb4_unicode_nopad_ci utf8mb4 1248 # #
|
|
utf8mb4_unicode_520_nopad_ci utf8mb4 1270 # #
|
|
uca1400_ai_ci NULL NULL NULL # #
|
|
uca1400_ai_cs NULL NULL NULL # #
|
|
uca1400_as_ci NULL NULL NULL # #
|
|
uca1400_as_cs NULL NULL NULL # #
|
|
uca1400_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_icelandic_ai_ci NULL NULL NULL # #
|
|
uca1400_icelandic_ai_cs NULL NULL NULL # #
|
|
uca1400_icelandic_as_ci NULL NULL NULL # #
|
|
uca1400_icelandic_as_cs NULL NULL NULL # #
|
|
uca1400_icelandic_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_icelandic_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_icelandic_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_icelandic_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_latvian_ai_ci NULL NULL NULL # #
|
|
uca1400_latvian_ai_cs NULL NULL NULL # #
|
|
uca1400_latvian_as_ci NULL NULL NULL # #
|
|
uca1400_latvian_as_cs NULL NULL NULL # #
|
|
uca1400_latvian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_latvian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_latvian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_latvian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_romanian_ai_ci NULL NULL NULL # #
|
|
uca1400_romanian_ai_cs NULL NULL NULL # #
|
|
uca1400_romanian_as_ci NULL NULL NULL # #
|
|
uca1400_romanian_as_cs NULL NULL NULL # #
|
|
uca1400_romanian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_romanian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_romanian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_romanian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_slovenian_ai_ci NULL NULL NULL # #
|
|
uca1400_slovenian_ai_cs NULL NULL NULL # #
|
|
uca1400_slovenian_as_ci NULL NULL NULL # #
|
|
uca1400_slovenian_as_cs NULL NULL NULL # #
|
|
uca1400_slovenian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_slovenian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_slovenian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_slovenian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_polish_ai_ci NULL NULL NULL # #
|
|
uca1400_polish_ai_cs NULL NULL NULL # #
|
|
uca1400_polish_as_ci NULL NULL NULL # #
|
|
uca1400_polish_as_cs NULL NULL NULL # #
|
|
uca1400_polish_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_polish_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_polish_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_polish_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_estonian_ai_ci NULL NULL NULL # #
|
|
uca1400_estonian_ai_cs NULL NULL NULL # #
|
|
uca1400_estonian_as_ci NULL NULL NULL # #
|
|
uca1400_estonian_as_cs NULL NULL NULL # #
|
|
uca1400_estonian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_estonian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_estonian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_estonian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_spanish_ai_ci NULL NULL NULL # #
|
|
uca1400_spanish_ai_cs NULL NULL NULL # #
|
|
uca1400_spanish_as_ci NULL NULL NULL # #
|
|
uca1400_spanish_as_cs NULL NULL NULL # #
|
|
uca1400_spanish_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_spanish_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_spanish_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_spanish_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_swedish_ai_ci NULL NULL NULL # #
|
|
uca1400_swedish_ai_cs NULL NULL NULL # #
|
|
uca1400_swedish_as_ci NULL NULL NULL # #
|
|
uca1400_swedish_as_cs NULL NULL NULL # #
|
|
uca1400_swedish_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_swedish_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_swedish_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_swedish_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_turkish_ai_ci NULL NULL NULL # #
|
|
uca1400_turkish_ai_cs NULL NULL NULL # #
|
|
uca1400_turkish_as_ci NULL NULL NULL # #
|
|
uca1400_turkish_as_cs NULL NULL NULL # #
|
|
uca1400_turkish_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_turkish_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_turkish_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_turkish_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_czech_ai_ci NULL NULL NULL # #
|
|
uca1400_czech_ai_cs NULL NULL NULL # #
|
|
uca1400_czech_as_ci NULL NULL NULL # #
|
|
uca1400_czech_as_cs NULL NULL NULL # #
|
|
uca1400_czech_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_czech_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_czech_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_czech_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_danish_ai_ci NULL NULL NULL # #
|
|
uca1400_danish_ai_cs NULL NULL NULL # #
|
|
uca1400_danish_as_ci NULL NULL NULL # #
|
|
uca1400_danish_as_cs NULL NULL NULL # #
|
|
uca1400_danish_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_danish_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_danish_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_danish_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_lithuanian_ai_ci NULL NULL NULL # #
|
|
uca1400_lithuanian_ai_cs NULL NULL NULL # #
|
|
uca1400_lithuanian_as_ci NULL NULL NULL # #
|
|
uca1400_lithuanian_as_cs NULL NULL NULL # #
|
|
uca1400_lithuanian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_lithuanian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_lithuanian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_lithuanian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_slovak_ai_ci NULL NULL NULL # #
|
|
uca1400_slovak_ai_cs NULL NULL NULL # #
|
|
uca1400_slovak_as_ci NULL NULL NULL # #
|
|
uca1400_slovak_as_cs NULL NULL NULL # #
|
|
uca1400_slovak_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_slovak_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_slovak_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_slovak_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_spanish2_ai_ci NULL NULL NULL # #
|
|
uca1400_spanish2_ai_cs NULL NULL NULL # #
|
|
uca1400_spanish2_as_ci NULL NULL NULL # #
|
|
uca1400_spanish2_as_cs NULL NULL NULL # #
|
|
uca1400_spanish2_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_spanish2_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_spanish2_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_spanish2_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_roman_ai_ci NULL NULL NULL # #
|
|
uca1400_roman_ai_cs NULL NULL NULL # #
|
|
uca1400_roman_as_ci NULL NULL NULL # #
|
|
uca1400_roman_as_cs NULL NULL NULL # #
|
|
uca1400_roman_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_roman_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_roman_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_roman_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_persian_ai_ci NULL NULL NULL # #
|
|
uca1400_persian_ai_cs NULL NULL NULL # #
|
|
uca1400_persian_as_ci NULL NULL NULL # #
|
|
uca1400_persian_as_cs NULL NULL NULL # #
|
|
uca1400_persian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_persian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_persian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_persian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_esperanto_ai_ci NULL NULL NULL # #
|
|
uca1400_esperanto_ai_cs NULL NULL NULL # #
|
|
uca1400_esperanto_as_ci NULL NULL NULL # #
|
|
uca1400_esperanto_as_cs NULL NULL NULL # #
|
|
uca1400_esperanto_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_esperanto_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_esperanto_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_esperanto_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_hungarian_ai_ci NULL NULL NULL # #
|
|
uca1400_hungarian_ai_cs NULL NULL NULL # #
|
|
uca1400_hungarian_as_ci NULL NULL NULL # #
|
|
uca1400_hungarian_as_cs NULL NULL NULL # #
|
|
uca1400_hungarian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_hungarian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_hungarian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_hungarian_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_sinhala_ai_ci NULL NULL NULL # #
|
|
uca1400_sinhala_ai_cs NULL NULL NULL # #
|
|
uca1400_sinhala_as_ci NULL NULL NULL # #
|
|
uca1400_sinhala_as_cs NULL NULL NULL # #
|
|
uca1400_sinhala_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_sinhala_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_sinhala_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_sinhala_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_german2_ai_ci NULL NULL NULL # #
|
|
uca1400_german2_ai_cs NULL NULL NULL # #
|
|
uca1400_german2_as_ci NULL NULL NULL # #
|
|
uca1400_german2_as_cs NULL NULL NULL # #
|
|
uca1400_german2_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_german2_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_german2_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_german2_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_vietnamese_ai_ci NULL NULL NULL # #
|
|
uca1400_vietnamese_ai_cs NULL NULL NULL # #
|
|
uca1400_vietnamese_as_ci NULL NULL NULL # #
|
|
uca1400_vietnamese_as_cs NULL NULL NULL # #
|
|
uca1400_vietnamese_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_vietnamese_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_vietnamese_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_vietnamese_nopad_as_cs NULL NULL NULL # #
|
|
uca1400_croatian_ai_ci NULL NULL NULL # #
|
|
uca1400_croatian_ai_cs NULL NULL NULL # #
|
|
uca1400_croatian_as_ci NULL NULL NULL # #
|
|
uca1400_croatian_as_cs NULL NULL NULL # #
|
|
uca1400_croatian_nopad_ai_ci NULL NULL NULL # #
|
|
uca1400_croatian_nopad_ai_cs NULL NULL NULL # #
|
|
uca1400_croatian_nopad_as_ci NULL NULL NULL # #
|
|
uca1400_croatian_nopad_as_cs NULL NULL NULL # #
|
|
cp1251_bulgarian_ci cp1251 14 # #
|
|
cp1251_ukrainian_ci cp1251 23 # #
|
|
cp1251_bin cp1251 50 # #
|
|
cp1251_general_ci cp1251 51 Yes # #
|
|
cp1251_general_cs cp1251 52 # #
|
|
cp1251_nopad_bin cp1251 1074 # #
|
|
cp1251_general_nopad_ci cp1251 1075 # #
|
|
utf16_general_ci utf16 54 Yes # #
|
|
utf16_bin utf16 55 # #
|
|
utf16_unicode_ci utf16 101 # #
|
|
utf16_icelandic_ci utf16 102 # #
|
|
utf16_latvian_ci utf16 103 # #
|
|
utf16_romanian_ci utf16 104 # #
|
|
utf16_slovenian_ci utf16 105 # #
|
|
utf16_polish_ci utf16 106 # #
|
|
utf16_estonian_ci utf16 107 # #
|
|
utf16_spanish_ci utf16 108 # #
|
|
utf16_swedish_ci utf16 109 # #
|
|
utf16_turkish_ci utf16 110 # #
|
|
utf16_czech_ci utf16 111 # #
|
|
utf16_danish_ci utf16 112 # #
|
|
utf16_lithuanian_ci utf16 113 # #
|
|
utf16_slovak_ci utf16 114 # #
|
|
utf16_spanish2_ci utf16 115 # #
|
|
utf16_roman_ci utf16 116 # #
|
|
utf16_persian_ci utf16 117 # #
|
|
utf16_esperanto_ci utf16 118 # #
|
|
utf16_hungarian_ci utf16 119 # #
|
|
utf16_sinhala_ci utf16 120 # #
|
|
utf16_german2_ci utf16 121 # #
|
|
utf16_croatian_mysql561_ci utf16 122 # #
|
|
utf16_unicode_520_ci utf16 123 # #
|
|
utf16_vietnamese_ci utf16 124 # #
|
|
utf16_croatian_ci utf16 672 # #
|
|
utf16_myanmar_ci utf16 673 # #
|
|
utf16_thai_520_w2 utf16 674 # #
|
|
utf16_general_nopad_ci utf16 1078 # #
|
|
utf16_nopad_bin utf16 1079 # #
|
|
utf16_unicode_nopad_ci utf16 1125 # #
|
|
utf16_unicode_520_nopad_ci utf16 1147 # #
|
|
utf16le_general_ci utf16le 56 Yes # #
|
|
utf16le_bin utf16le 62 # #
|
|
utf16le_general_nopad_ci utf16le 1080 # #
|
|
utf16le_nopad_bin utf16le 1086 # #
|
|
cp1256_general_ci cp1256 57 Yes # #
|
|
cp1256_bin cp1256 67 # #
|
|
cp1256_general_nopad_ci cp1256 1081 # #
|
|
cp1256_nopad_bin cp1256 1091 # #
|
|
cp1257_lithuanian_ci cp1257 29 # #
|
|
cp1257_bin cp1257 58 # #
|
|
cp1257_general_ci cp1257 59 Yes # #
|
|
cp1257_nopad_bin cp1257 1082 # #
|
|
cp1257_general_nopad_ci cp1257 1083 # #
|
|
utf32_general_ci utf32 60 Yes # #
|
|
utf32_bin utf32 61 # #
|
|
utf32_unicode_ci utf32 160 # #
|
|
utf32_icelandic_ci utf32 161 # #
|
|
utf32_latvian_ci utf32 162 # #
|
|
utf32_romanian_ci utf32 163 # #
|
|
utf32_slovenian_ci utf32 164 # #
|
|
utf32_polish_ci utf32 165 # #
|
|
utf32_estonian_ci utf32 166 # #
|
|
utf32_spanish_ci utf32 167 # #
|
|
utf32_swedish_ci utf32 168 # #
|
|
utf32_turkish_ci utf32 169 # #
|
|
utf32_czech_ci utf32 170 # #
|
|
utf32_danish_ci utf32 171 # #
|
|
utf32_lithuanian_ci utf32 172 # #
|
|
utf32_slovak_ci utf32 173 # #
|
|
utf32_spanish2_ci utf32 174 # #
|
|
utf32_roman_ci utf32 175 # #
|
|
utf32_persian_ci utf32 176 # #
|
|
utf32_esperanto_ci utf32 177 # #
|
|
utf32_hungarian_ci utf32 178 # #
|
|
utf32_sinhala_ci utf32 179 # #
|
|
utf32_german2_ci utf32 180 # #
|
|
utf32_croatian_mysql561_ci utf32 181 # #
|
|
utf32_unicode_520_ci utf32 182 # #
|
|
utf32_vietnamese_ci utf32 183 # #
|
|
utf32_croatian_ci utf32 736 # #
|
|
utf32_myanmar_ci utf32 737 # #
|
|
utf32_thai_520_w2 utf32 738 # #
|
|
utf32_general_nopad_ci utf32 1084 # #
|
|
utf32_nopad_bin utf32 1085 # #
|
|
utf32_unicode_nopad_ci utf32 1184 # #
|
|
utf32_unicode_520_nopad_ci utf32 1206 # #
|
|
binary binary 63 Yes # #
|
|
geostd8_general_ci geostd8 92 Yes # #
|
|
geostd8_bin geostd8 93 # #
|
|
geostd8_general_nopad_ci geostd8 1116 # #
|
|
geostd8_nopad_bin geostd8 1117 # #
|
|
cp932_japanese_ci cp932 95 Yes # #
|
|
cp932_bin cp932 96 # #
|
|
cp932_japanese_nopad_ci cp932 1119 # #
|
|
cp932_nopad_bin cp932 1120 # #
|
|
eucjpms_japanese_ci eucjpms 97 Yes # #
|
|
eucjpms_bin eucjpms 98 # #
|
|
eucjpms_japanese_nopad_ci eucjpms 1121 # #
|
|
eucjpms_nopad_bin eucjpms 1122 # #
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_general_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_general_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_bin;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_bin NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_bin;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_bin NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_unicode_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_unicode_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_unicode_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_unicode_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_icelandic_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_icelandic_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_icelandic_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_icelandic_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_latvian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_latvian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_latvian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_latvian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_romanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_romanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_romanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_romanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_slovenian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovenian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_slovenian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovenian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_polish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_polish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_polish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_polish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_estonian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_estonian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_estonian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_estonian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_spanish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_swedish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_swedish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_swedish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_swedish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_turkish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_turkish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_turkish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_turkish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_czech_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_czech_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_czech_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_czech_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_danish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_danish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_danish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_danish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_lithuanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_lithuanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_lithuanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_lithuanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_slovak_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovak_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_slovak_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovak_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_spanish2_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish2_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish2_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish2_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_roman_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_roman_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_roman_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_roman_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_persian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_persian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_persian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_persian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_esperanto_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_esperanto_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_esperanto_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_esperanto_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 COLLATE utf8_hungarian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_hungarian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER DATABASE d10 DEFAULT COLLATE utf8_hungarian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_hungarian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_general_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_general_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_bin;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_bin NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_bin;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_bin NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_unicode_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_unicode_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_unicode_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_unicode_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_icelandic_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_icelandic_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_icelandic_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_icelandic_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_latvian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_latvian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_latvian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_latvian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_romanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_romanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_romanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_romanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_slovenian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovenian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovenian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovenian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_polish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_polish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_polish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_polish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_estonian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_estonian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_estonian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_estonian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_spanish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_swedish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_swedish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_swedish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_swedish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_turkish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_turkish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_turkish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_turkish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_czech_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_czech_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_czech_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_czech_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_danish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_danish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_danish_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_danish_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_lithuanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_lithuanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_lithuanian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_lithuanian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_slovak_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovak_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovak_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_slovak_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_spanish2_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish2_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish2_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_spanish2_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_roman_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_roman_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_roman_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_roman_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_persian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_persian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_persian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_persian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_esperanto_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_esperanto_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_esperanto_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_esperanto_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 COLLATE utf8_hungarian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_hungarian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|
|
CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_general_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
ALTER SCHEMA d10 DEFAULT COLLATE utf8_hungarian_ci;
|
|
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
|
|
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
|
|
def d10 utf8mb3 utf8mb3_hungarian_ci NULL
|
|
def information_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def mtr latin1 latin1_swedish_ci NULL
|
|
def mysql latin1 latin1_swedish_ci NULL
|
|
def performance_schema utf8mb3 utf8mb3_general_ci NULL
|
|
def sys utf8mb3 utf8mb3_general_ci NULL
|
|
def test latin1 latin1_swedish_ci NULL
|
|
DROP DATABASE d10;
|