1DROP DATABASE IF EXISTS d10; 2SHOW COLLATION; 3Collation Charset Id Default Compiled Sortlen 4big5_chinese_ci big5 1 Yes # # 5big5_bin big5 84 # # 6big5_chinese_nopad_ci big5 1025 # # 7big5_nopad_bin big5 1108 # # 8dec8_swedish_ci dec8 3 Yes # # 9dec8_bin dec8 69 # # 10dec8_swedish_nopad_ci dec8 1027 # # 11dec8_nopad_bin dec8 1093 # # 12cp850_general_ci cp850 4 Yes # # 13cp850_bin cp850 80 # # 14cp850_general_nopad_ci cp850 1028 # # 15cp850_nopad_bin cp850 1104 # # 16hp8_english_ci hp8 6 Yes # # 17hp8_bin hp8 72 # # 18hp8_english_nopad_ci hp8 1030 # # 19hp8_nopad_bin hp8 1096 # # 20koi8r_general_ci koi8r 7 Yes # # 21koi8r_bin koi8r 74 # # 22koi8r_general_nopad_ci koi8r 1031 # # 23koi8r_nopad_bin koi8r 1098 # # 24latin1_german1_ci latin1 5 # # 25latin1_swedish_ci latin1 8 Yes # # 26latin1_danish_ci latin1 15 # # 27latin1_german2_ci latin1 31 # # 28latin1_bin latin1 47 # # 29latin1_general_ci latin1 48 # # 30latin1_general_cs latin1 49 # # 31latin1_spanish_ci latin1 94 # # 32latin1_swedish_nopad_ci latin1 1032 # # 33latin1_nopad_bin latin1 1071 # # 34latin2_czech_cs latin2 2 # # 35latin2_general_ci latin2 9 Yes # # 36latin2_hungarian_ci latin2 21 # # 37latin2_croatian_ci latin2 27 # # 38latin2_bin latin2 77 # # 39latin2_general_nopad_ci latin2 1033 # # 40latin2_nopad_bin latin2 1101 # # 41swe7_swedish_ci swe7 10 Yes # # 42swe7_bin swe7 82 # # 43swe7_swedish_nopad_ci swe7 1034 # # 44swe7_nopad_bin swe7 1106 # # 45ascii_general_ci ascii 11 Yes # # 46ascii_bin ascii 65 # # 47ascii_general_nopad_ci ascii 1035 # # 48ascii_nopad_bin ascii 1089 # # 49ujis_japanese_ci ujis 12 Yes # # 50ujis_bin ujis 91 # # 51ujis_japanese_nopad_ci ujis 1036 # # 52ujis_nopad_bin ujis 1115 # # 53sjis_japanese_ci sjis 13 Yes # # 54sjis_bin sjis 88 # # 55sjis_japanese_nopad_ci sjis 1037 # # 56sjis_nopad_bin sjis 1112 # # 57hebrew_general_ci hebrew 16 Yes # # 58hebrew_bin hebrew 71 # # 59hebrew_general_nopad_ci hebrew 1040 # # 60hebrew_nopad_bin hebrew 1095 # # 61tis620_thai_ci tis620 18 Yes # # 62tis620_bin tis620 89 # # 63tis620_thai_nopad_ci tis620 1042 # # 64tis620_nopad_bin tis620 1113 # # 65euckr_korean_ci euckr 19 Yes # # 66euckr_bin euckr 85 # # 67euckr_korean_nopad_ci euckr 1043 # # 68euckr_nopad_bin euckr 1109 # # 69koi8u_general_ci koi8u 22 Yes # # 70koi8u_bin koi8u 75 # # 71koi8u_general_nopad_ci koi8u 1046 # # 72koi8u_nopad_bin koi8u 1099 # # 73gb2312_chinese_ci gb2312 24 Yes # # 74gb2312_bin gb2312 86 # # 75gb2312_chinese_nopad_ci gb2312 1048 # # 76gb2312_nopad_bin gb2312 1110 # # 77greek_general_ci greek 25 Yes # # 78greek_bin greek 70 # # 79greek_general_nopad_ci greek 1049 # # 80greek_nopad_bin greek 1094 # # 81cp1250_general_ci cp1250 26 Yes # # 82cp1250_czech_cs cp1250 34 # # 83cp1250_croatian_ci cp1250 44 # # 84cp1250_bin cp1250 66 # # 85cp1250_polish_ci cp1250 99 # # 86cp1250_general_nopad_ci cp1250 1050 # # 87cp1250_nopad_bin cp1250 1090 # # 88gbk_chinese_ci gbk 28 Yes # # 89gbk_bin gbk 87 # # 90gbk_chinese_nopad_ci gbk 1052 # # 91gbk_nopad_bin gbk 1111 # # 92latin5_turkish_ci latin5 30 Yes # # 93latin5_bin latin5 78 # # 94latin5_turkish_nopad_ci latin5 1054 # # 95latin5_nopad_bin latin5 1102 # # 96armscii8_general_ci armscii8 32 Yes # # 97armscii8_bin armscii8 64 # # 98armscii8_general_nopad_ci armscii8 1056 # # 99armscii8_nopad_bin armscii8 1088 # # 100utf8_general_ci utf8 33 Yes # # 101utf8_bin utf8 83 # # 102utf8_unicode_ci utf8 192 # # 103utf8_icelandic_ci utf8 193 # # 104utf8_latvian_ci utf8 194 # # 105utf8_romanian_ci utf8 195 # # 106utf8_slovenian_ci utf8 196 # # 107utf8_polish_ci utf8 197 # # 108utf8_estonian_ci utf8 198 # # 109utf8_spanish_ci utf8 199 # # 110utf8_swedish_ci utf8 200 # # 111utf8_turkish_ci utf8 201 # # 112utf8_czech_ci utf8 202 # # 113utf8_danish_ci utf8 203 # # 114utf8_lithuanian_ci utf8 204 # # 115utf8_slovak_ci utf8 205 # # 116utf8_spanish2_ci utf8 206 # # 117utf8_roman_ci utf8 207 # # 118utf8_persian_ci utf8 208 # # 119utf8_esperanto_ci utf8 209 # # 120utf8_hungarian_ci utf8 210 # # 121utf8_sinhala_ci utf8 211 # # 122utf8_german2_ci utf8 212 # # 123utf8_croatian_mysql561_ci utf8 213 # # 124utf8_unicode_520_ci utf8 214 # # 125utf8_vietnamese_ci utf8 215 # # 126utf8_general_mysql500_ci utf8 223 # # 127utf8_croatian_ci utf8 576 # # 128utf8_myanmar_ci utf8 577 # # 129utf8_thai_520_w2 utf8 578 # # 130utf8_general_nopad_ci utf8 1057 # # 131utf8_nopad_bin utf8 1107 # # 132utf8_unicode_nopad_ci utf8 1216 # # 133utf8_unicode_520_nopad_ci utf8 1238 # # 134ucs2_general_ci ucs2 35 Yes # # 135ucs2_bin ucs2 90 # # 136ucs2_unicode_ci ucs2 128 # # 137ucs2_icelandic_ci ucs2 129 # # 138ucs2_latvian_ci ucs2 130 # # 139ucs2_romanian_ci ucs2 131 # # 140ucs2_slovenian_ci ucs2 132 # # 141ucs2_polish_ci ucs2 133 # # 142ucs2_estonian_ci ucs2 134 # # 143ucs2_spanish_ci ucs2 135 # # 144ucs2_swedish_ci ucs2 136 # # 145ucs2_turkish_ci ucs2 137 # # 146ucs2_czech_ci ucs2 138 # # 147ucs2_danish_ci ucs2 139 # # 148ucs2_lithuanian_ci ucs2 140 # # 149ucs2_slovak_ci ucs2 141 # # 150ucs2_spanish2_ci ucs2 142 # # 151ucs2_roman_ci ucs2 143 # # 152ucs2_persian_ci ucs2 144 # # 153ucs2_esperanto_ci ucs2 145 # # 154ucs2_hungarian_ci ucs2 146 # # 155ucs2_sinhala_ci ucs2 147 # # 156ucs2_german2_ci ucs2 148 # # 157ucs2_croatian_mysql561_ci ucs2 149 # # 158ucs2_unicode_520_ci ucs2 150 # # 159ucs2_vietnamese_ci ucs2 151 # # 160ucs2_general_mysql500_ci ucs2 159 # # 161ucs2_croatian_ci ucs2 640 # # 162ucs2_myanmar_ci ucs2 641 # # 163ucs2_thai_520_w2 ucs2 642 # # 164ucs2_general_nopad_ci ucs2 1059 # # 165ucs2_nopad_bin ucs2 1114 # # 166ucs2_unicode_nopad_ci ucs2 1152 # # 167ucs2_unicode_520_nopad_ci ucs2 1174 # # 168cp866_general_ci cp866 36 Yes # # 169cp866_bin cp866 68 # # 170cp866_general_nopad_ci cp866 1060 # # 171cp866_nopad_bin cp866 1092 # # 172keybcs2_general_ci keybcs2 37 Yes # # 173keybcs2_bin keybcs2 73 # # 174keybcs2_general_nopad_ci keybcs2 1061 # # 175keybcs2_nopad_bin keybcs2 1097 # # 176macce_general_ci macce 38 Yes # # 177macce_bin macce 43 # # 178macce_general_nopad_ci macce 1062 # # 179macce_nopad_bin macce 1067 # # 180macroman_general_ci macroman 39 Yes # # 181macroman_bin macroman 53 # # 182macroman_general_nopad_ci macroman 1063 # # 183macroman_nopad_bin macroman 1077 # # 184cp852_general_ci cp852 40 Yes # # 185cp852_bin cp852 81 # # 186cp852_general_nopad_ci cp852 1064 # # 187cp852_nopad_bin cp852 1105 # # 188latin7_estonian_cs latin7 20 # # 189latin7_general_ci latin7 41 Yes # # 190latin7_general_cs latin7 42 # # 191latin7_bin latin7 79 # # 192latin7_general_nopad_ci latin7 1065 # # 193latin7_nopad_bin latin7 1103 # # 194utf8mb4_general_ci utf8mb4 45 Yes # # 195utf8mb4_bin utf8mb4 46 # # 196utf8mb4_unicode_ci utf8mb4 224 # # 197utf8mb4_icelandic_ci utf8mb4 225 # # 198utf8mb4_latvian_ci utf8mb4 226 # # 199utf8mb4_romanian_ci utf8mb4 227 # # 200utf8mb4_slovenian_ci utf8mb4 228 # # 201utf8mb4_polish_ci utf8mb4 229 # # 202utf8mb4_estonian_ci utf8mb4 230 # # 203utf8mb4_spanish_ci utf8mb4 231 # # 204utf8mb4_swedish_ci utf8mb4 232 # # 205utf8mb4_turkish_ci utf8mb4 233 # # 206utf8mb4_czech_ci utf8mb4 234 # # 207utf8mb4_danish_ci utf8mb4 235 # # 208utf8mb4_lithuanian_ci utf8mb4 236 # # 209utf8mb4_slovak_ci utf8mb4 237 # # 210utf8mb4_spanish2_ci utf8mb4 238 # # 211utf8mb4_roman_ci utf8mb4 239 # # 212utf8mb4_persian_ci utf8mb4 240 # # 213utf8mb4_esperanto_ci utf8mb4 241 # # 214utf8mb4_hungarian_ci utf8mb4 242 # # 215utf8mb4_sinhala_ci utf8mb4 243 # # 216utf8mb4_german2_ci utf8mb4 244 # # 217utf8mb4_croatian_mysql561_ci utf8mb4 245 # # 218utf8mb4_unicode_520_ci utf8mb4 246 # # 219utf8mb4_vietnamese_ci utf8mb4 247 # # 220utf8mb4_croatian_ci utf8mb4 608 # # 221utf8mb4_myanmar_ci utf8mb4 609 # # 222utf8mb4_thai_520_w2 utf8mb4 610 # # 223utf8mb4_general_nopad_ci utf8mb4 1069 # # 224utf8mb4_nopad_bin utf8mb4 1070 # # 225utf8mb4_unicode_nopad_ci utf8mb4 1248 # # 226utf8mb4_unicode_520_nopad_ci utf8mb4 1270 # # 227cp1251_bulgarian_ci cp1251 14 # # 228cp1251_ukrainian_ci cp1251 23 # # 229cp1251_bin cp1251 50 # # 230cp1251_general_ci cp1251 51 Yes # # 231cp1251_general_cs cp1251 52 # # 232cp1251_nopad_bin cp1251 1074 # # 233cp1251_general_nopad_ci cp1251 1075 # # 234utf16_general_ci utf16 54 Yes # # 235utf16_bin utf16 55 # # 236utf16_unicode_ci utf16 101 # # 237utf16_icelandic_ci utf16 102 # # 238utf16_latvian_ci utf16 103 # # 239utf16_romanian_ci utf16 104 # # 240utf16_slovenian_ci utf16 105 # # 241utf16_polish_ci utf16 106 # # 242utf16_estonian_ci utf16 107 # # 243utf16_spanish_ci utf16 108 # # 244utf16_swedish_ci utf16 109 # # 245utf16_turkish_ci utf16 110 # # 246utf16_czech_ci utf16 111 # # 247utf16_danish_ci utf16 112 # # 248utf16_lithuanian_ci utf16 113 # # 249utf16_slovak_ci utf16 114 # # 250utf16_spanish2_ci utf16 115 # # 251utf16_roman_ci utf16 116 # # 252utf16_persian_ci utf16 117 # # 253utf16_esperanto_ci utf16 118 # # 254utf16_hungarian_ci utf16 119 # # 255utf16_sinhala_ci utf16 120 # # 256utf16_german2_ci utf16 121 # # 257utf16_croatian_mysql561_ci utf16 122 # # 258utf16_unicode_520_ci utf16 123 # # 259utf16_vietnamese_ci utf16 124 # # 260utf16_croatian_ci utf16 672 # # 261utf16_myanmar_ci utf16 673 # # 262utf16_thai_520_w2 utf16 674 # # 263utf16_general_nopad_ci utf16 1078 # # 264utf16_nopad_bin utf16 1079 # # 265utf16_unicode_nopad_ci utf16 1125 # # 266utf16_unicode_520_nopad_ci utf16 1147 # # 267utf16le_general_ci utf16le 56 Yes # # 268utf16le_bin utf16le 62 # # 269utf16le_general_nopad_ci utf16le 1080 # # 270utf16le_nopad_bin utf16le 1086 # # 271cp1256_general_ci cp1256 57 Yes # # 272cp1256_bin cp1256 67 # # 273cp1256_general_nopad_ci cp1256 1081 # # 274cp1256_nopad_bin cp1256 1091 # # 275cp1257_lithuanian_ci cp1257 29 # # 276cp1257_bin cp1257 58 # # 277cp1257_general_ci cp1257 59 Yes # # 278cp1257_nopad_bin cp1257 1082 # # 279cp1257_general_nopad_ci cp1257 1083 # # 280utf32_general_ci utf32 60 Yes # # 281utf32_bin utf32 61 # # 282utf32_unicode_ci utf32 160 # # 283utf32_icelandic_ci utf32 161 # # 284utf32_latvian_ci utf32 162 # # 285utf32_romanian_ci utf32 163 # # 286utf32_slovenian_ci utf32 164 # # 287utf32_polish_ci utf32 165 # # 288utf32_estonian_ci utf32 166 # # 289utf32_spanish_ci utf32 167 # # 290utf32_swedish_ci utf32 168 # # 291utf32_turkish_ci utf32 169 # # 292utf32_czech_ci utf32 170 # # 293utf32_danish_ci utf32 171 # # 294utf32_lithuanian_ci utf32 172 # # 295utf32_slovak_ci utf32 173 # # 296utf32_spanish2_ci utf32 174 # # 297utf32_roman_ci utf32 175 # # 298utf32_persian_ci utf32 176 # # 299utf32_esperanto_ci utf32 177 # # 300utf32_hungarian_ci utf32 178 # # 301utf32_sinhala_ci utf32 179 # # 302utf32_german2_ci utf32 180 # # 303utf32_croatian_mysql561_ci utf32 181 # # 304utf32_unicode_520_ci utf32 182 # # 305utf32_vietnamese_ci utf32 183 # # 306utf32_croatian_ci utf32 736 # # 307utf32_myanmar_ci utf32 737 # # 308utf32_thai_520_w2 utf32 738 # # 309utf32_general_nopad_ci utf32 1084 # # 310utf32_nopad_bin utf32 1085 # # 311utf32_unicode_nopad_ci utf32 1184 # # 312utf32_unicode_520_nopad_ci utf32 1206 # # 313binary binary 63 Yes # # 314geostd8_general_ci geostd8 92 Yes # # 315geostd8_bin geostd8 93 # # 316geostd8_general_nopad_ci geostd8 1116 # # 317geostd8_nopad_bin geostd8 1117 # # 318cp932_japanese_ci cp932 95 Yes # # 319cp932_bin cp932 96 # # 320cp932_japanese_nopad_ci cp932 1119 # # 321cp932_nopad_bin cp932 1120 # # 322eucjpms_japanese_ci eucjpms 97 Yes # # 323eucjpms_bin eucjpms 98 # # 324eucjpms_japanese_nopad_ci eucjpms 1121 # # 325eucjpms_nopad_bin eucjpms 1122 # # 326CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 327SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 328CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 329def d10 utf8 utf8_general_ci NULL 330def information_schema utf8 utf8_general_ci NULL 331def mtr latin1 latin1_swedish_ci NULL 332def mysql latin1 latin1_swedish_ci NULL 333def performance_schema utf8 utf8_general_ci NULL 334def test latin1 latin1_swedish_ci NULL 335ALTER DATABASE d10 COLLATE utf8_general_ci; 336SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 337CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 338def d10 utf8 utf8_general_ci NULL 339def information_schema utf8 utf8_general_ci NULL 340def mtr latin1 latin1_swedish_ci NULL 341def mysql latin1 latin1_swedish_ci NULL 342def performance_schema utf8 utf8_general_ci NULL 343def test latin1 latin1_swedish_ci NULL 344DROP DATABASE d10; 345CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 346SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 347CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 348def d10 utf8 utf8_general_ci NULL 349def information_schema utf8 utf8_general_ci NULL 350def mtr latin1 latin1_swedish_ci NULL 351def mysql latin1 latin1_swedish_ci NULL 352def performance_schema utf8 utf8_general_ci NULL 353def test latin1 latin1_swedish_ci NULL 354ALTER DATABASE d10 DEFAULT COLLATE utf8_general_ci; 355SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 356CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 357def d10 utf8 utf8_general_ci NULL 358def information_schema utf8 utf8_general_ci NULL 359def mtr latin1 latin1_swedish_ci NULL 360def mysql latin1 latin1_swedish_ci NULL 361def performance_schema utf8 utf8_general_ci NULL 362def test latin1 latin1_swedish_ci NULL 363DROP DATABASE d10; 364CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 365SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 366CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 367def d10 utf8 utf8_general_ci NULL 368def information_schema utf8 utf8_general_ci NULL 369def mtr latin1 latin1_swedish_ci NULL 370def mysql latin1 latin1_swedish_ci NULL 371def performance_schema utf8 utf8_general_ci NULL 372def test latin1 latin1_swedish_ci NULL 373ALTER DATABASE d10 COLLATE utf8_bin; 374SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 375CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 376def d10 utf8 utf8_bin NULL 377def information_schema utf8 utf8_general_ci NULL 378def mtr latin1 latin1_swedish_ci NULL 379def mysql latin1 latin1_swedish_ci NULL 380def performance_schema utf8 utf8_general_ci NULL 381def test latin1 latin1_swedish_ci NULL 382DROP DATABASE d10; 383CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 384SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 385CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 386def d10 utf8 utf8_general_ci NULL 387def information_schema utf8 utf8_general_ci NULL 388def mtr latin1 latin1_swedish_ci NULL 389def mysql latin1 latin1_swedish_ci NULL 390def performance_schema utf8 utf8_general_ci NULL 391def test latin1 latin1_swedish_ci NULL 392ALTER DATABASE d10 DEFAULT COLLATE utf8_bin; 393SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 394CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 395def d10 utf8 utf8_bin NULL 396def information_schema utf8 utf8_general_ci NULL 397def mtr latin1 latin1_swedish_ci NULL 398def mysql latin1 latin1_swedish_ci NULL 399def performance_schema utf8 utf8_general_ci NULL 400def test latin1 latin1_swedish_ci NULL 401DROP DATABASE d10; 402CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 403SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 404CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 405def d10 utf8 utf8_general_ci NULL 406def information_schema utf8 utf8_general_ci NULL 407def mtr latin1 latin1_swedish_ci NULL 408def mysql latin1 latin1_swedish_ci NULL 409def performance_schema utf8 utf8_general_ci NULL 410def test latin1 latin1_swedish_ci NULL 411ALTER DATABASE d10 COLLATE utf8_unicode_ci; 412SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 413CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 414def d10 utf8 utf8_unicode_ci NULL 415def information_schema utf8 utf8_general_ci NULL 416def mtr latin1 latin1_swedish_ci NULL 417def mysql latin1 latin1_swedish_ci NULL 418def performance_schema utf8 utf8_general_ci NULL 419def test latin1 latin1_swedish_ci NULL 420DROP DATABASE d10; 421CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 422SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 423CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 424def d10 utf8 utf8_general_ci NULL 425def information_schema utf8 utf8_general_ci NULL 426def mtr latin1 latin1_swedish_ci NULL 427def mysql latin1 latin1_swedish_ci NULL 428def performance_schema utf8 utf8_general_ci NULL 429def test latin1 latin1_swedish_ci NULL 430ALTER DATABASE d10 DEFAULT COLLATE utf8_unicode_ci; 431SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 432CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 433def d10 utf8 utf8_unicode_ci NULL 434def information_schema utf8 utf8_general_ci NULL 435def mtr latin1 latin1_swedish_ci NULL 436def mysql latin1 latin1_swedish_ci NULL 437def performance_schema utf8 utf8_general_ci NULL 438def test latin1 latin1_swedish_ci NULL 439DROP DATABASE d10; 440CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 441SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 442CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 443def d10 utf8 utf8_general_ci NULL 444def information_schema utf8 utf8_general_ci NULL 445def mtr latin1 latin1_swedish_ci NULL 446def mysql latin1 latin1_swedish_ci NULL 447def performance_schema utf8 utf8_general_ci NULL 448def test latin1 latin1_swedish_ci NULL 449ALTER DATABASE d10 COLLATE utf8_icelandic_ci; 450SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 451CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 452def d10 utf8 utf8_icelandic_ci NULL 453def information_schema utf8 utf8_general_ci NULL 454def mtr latin1 latin1_swedish_ci NULL 455def mysql latin1 latin1_swedish_ci NULL 456def performance_schema utf8 utf8_general_ci NULL 457def test latin1 latin1_swedish_ci NULL 458DROP DATABASE d10; 459CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 460SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 461CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 462def d10 utf8 utf8_general_ci NULL 463def information_schema utf8 utf8_general_ci NULL 464def mtr latin1 latin1_swedish_ci NULL 465def mysql latin1 latin1_swedish_ci NULL 466def performance_schema utf8 utf8_general_ci NULL 467def test latin1 latin1_swedish_ci NULL 468ALTER DATABASE d10 DEFAULT COLLATE utf8_icelandic_ci; 469SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 470CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 471def d10 utf8 utf8_icelandic_ci NULL 472def information_schema utf8 utf8_general_ci NULL 473def mtr latin1 latin1_swedish_ci NULL 474def mysql latin1 latin1_swedish_ci NULL 475def performance_schema utf8 utf8_general_ci NULL 476def test latin1 latin1_swedish_ci NULL 477DROP DATABASE d10; 478CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 479SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 480CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 481def d10 utf8 utf8_general_ci NULL 482def information_schema utf8 utf8_general_ci NULL 483def mtr latin1 latin1_swedish_ci NULL 484def mysql latin1 latin1_swedish_ci NULL 485def performance_schema utf8 utf8_general_ci NULL 486def test latin1 latin1_swedish_ci NULL 487ALTER DATABASE d10 COLLATE utf8_latvian_ci; 488SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 489CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 490def d10 utf8 utf8_latvian_ci NULL 491def information_schema utf8 utf8_general_ci NULL 492def mtr latin1 latin1_swedish_ci NULL 493def mysql latin1 latin1_swedish_ci NULL 494def performance_schema utf8 utf8_general_ci NULL 495def test latin1 latin1_swedish_ci NULL 496DROP DATABASE d10; 497CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 498SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 499CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 500def d10 utf8 utf8_general_ci NULL 501def information_schema utf8 utf8_general_ci NULL 502def mtr latin1 latin1_swedish_ci NULL 503def mysql latin1 latin1_swedish_ci NULL 504def performance_schema utf8 utf8_general_ci NULL 505def test latin1 latin1_swedish_ci NULL 506ALTER DATABASE d10 DEFAULT COLLATE utf8_latvian_ci; 507SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 508CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 509def d10 utf8 utf8_latvian_ci NULL 510def information_schema utf8 utf8_general_ci NULL 511def mtr latin1 latin1_swedish_ci NULL 512def mysql latin1 latin1_swedish_ci NULL 513def performance_schema utf8 utf8_general_ci NULL 514def test latin1 latin1_swedish_ci NULL 515DROP DATABASE d10; 516CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 517SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 518CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 519def d10 utf8 utf8_general_ci NULL 520def information_schema utf8 utf8_general_ci NULL 521def mtr latin1 latin1_swedish_ci NULL 522def mysql latin1 latin1_swedish_ci NULL 523def performance_schema utf8 utf8_general_ci NULL 524def test latin1 latin1_swedish_ci NULL 525ALTER DATABASE d10 COLLATE utf8_romanian_ci; 526SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 527CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 528def d10 utf8 utf8_romanian_ci NULL 529def information_schema utf8 utf8_general_ci NULL 530def mtr latin1 latin1_swedish_ci NULL 531def mysql latin1 latin1_swedish_ci NULL 532def performance_schema utf8 utf8_general_ci NULL 533def test latin1 latin1_swedish_ci NULL 534DROP DATABASE d10; 535CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 536SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 537CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 538def d10 utf8 utf8_general_ci NULL 539def information_schema utf8 utf8_general_ci NULL 540def mtr latin1 latin1_swedish_ci NULL 541def mysql latin1 latin1_swedish_ci NULL 542def performance_schema utf8 utf8_general_ci NULL 543def test latin1 latin1_swedish_ci NULL 544ALTER DATABASE d10 DEFAULT COLLATE utf8_romanian_ci; 545SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 546CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 547def d10 utf8 utf8_romanian_ci NULL 548def information_schema utf8 utf8_general_ci NULL 549def mtr latin1 latin1_swedish_ci NULL 550def mysql latin1 latin1_swedish_ci NULL 551def performance_schema utf8 utf8_general_ci NULL 552def test latin1 latin1_swedish_ci NULL 553DROP DATABASE d10; 554CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 555SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 556CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 557def d10 utf8 utf8_general_ci NULL 558def information_schema utf8 utf8_general_ci NULL 559def mtr latin1 latin1_swedish_ci NULL 560def mysql latin1 latin1_swedish_ci NULL 561def performance_schema utf8 utf8_general_ci NULL 562def test latin1 latin1_swedish_ci NULL 563ALTER DATABASE d10 COLLATE utf8_slovenian_ci; 564SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 565CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 566def d10 utf8 utf8_slovenian_ci NULL 567def information_schema utf8 utf8_general_ci NULL 568def mtr latin1 latin1_swedish_ci NULL 569def mysql latin1 latin1_swedish_ci NULL 570def performance_schema utf8 utf8_general_ci NULL 571def test latin1 latin1_swedish_ci NULL 572DROP DATABASE d10; 573CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 574SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 575CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 576def d10 utf8 utf8_general_ci NULL 577def information_schema utf8 utf8_general_ci NULL 578def mtr latin1 latin1_swedish_ci NULL 579def mysql latin1 latin1_swedish_ci NULL 580def performance_schema utf8 utf8_general_ci NULL 581def test latin1 latin1_swedish_ci NULL 582ALTER DATABASE d10 DEFAULT COLLATE utf8_slovenian_ci; 583SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 584CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 585def d10 utf8 utf8_slovenian_ci NULL 586def information_schema utf8 utf8_general_ci NULL 587def mtr latin1 latin1_swedish_ci NULL 588def mysql latin1 latin1_swedish_ci NULL 589def performance_schema utf8 utf8_general_ci NULL 590def test latin1 latin1_swedish_ci NULL 591DROP DATABASE d10; 592CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 593SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 594CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 595def d10 utf8 utf8_general_ci NULL 596def information_schema utf8 utf8_general_ci NULL 597def mtr latin1 latin1_swedish_ci NULL 598def mysql latin1 latin1_swedish_ci NULL 599def performance_schema utf8 utf8_general_ci NULL 600def test latin1 latin1_swedish_ci NULL 601ALTER DATABASE d10 COLLATE utf8_polish_ci; 602SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 603CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 604def d10 utf8 utf8_polish_ci NULL 605def information_schema utf8 utf8_general_ci NULL 606def mtr latin1 latin1_swedish_ci NULL 607def mysql latin1 latin1_swedish_ci NULL 608def performance_schema utf8 utf8_general_ci NULL 609def test latin1 latin1_swedish_ci NULL 610DROP DATABASE d10; 611CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 612SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 613CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 614def d10 utf8 utf8_general_ci NULL 615def information_schema utf8 utf8_general_ci NULL 616def mtr latin1 latin1_swedish_ci NULL 617def mysql latin1 latin1_swedish_ci NULL 618def performance_schema utf8 utf8_general_ci NULL 619def test latin1 latin1_swedish_ci NULL 620ALTER DATABASE d10 DEFAULT COLLATE utf8_polish_ci; 621SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 622CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 623def d10 utf8 utf8_polish_ci NULL 624def information_schema utf8 utf8_general_ci NULL 625def mtr latin1 latin1_swedish_ci NULL 626def mysql latin1 latin1_swedish_ci NULL 627def performance_schema utf8 utf8_general_ci NULL 628def test latin1 latin1_swedish_ci NULL 629DROP DATABASE d10; 630CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 631SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 632CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 633def d10 utf8 utf8_general_ci NULL 634def information_schema utf8 utf8_general_ci NULL 635def mtr latin1 latin1_swedish_ci NULL 636def mysql latin1 latin1_swedish_ci NULL 637def performance_schema utf8 utf8_general_ci NULL 638def test latin1 latin1_swedish_ci NULL 639ALTER DATABASE d10 COLLATE utf8_estonian_ci; 640SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 641CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 642def d10 utf8 utf8_estonian_ci NULL 643def information_schema utf8 utf8_general_ci NULL 644def mtr latin1 latin1_swedish_ci NULL 645def mysql latin1 latin1_swedish_ci NULL 646def performance_schema utf8 utf8_general_ci NULL 647def test latin1 latin1_swedish_ci NULL 648DROP DATABASE d10; 649CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 650SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 651CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 652def d10 utf8 utf8_general_ci NULL 653def information_schema utf8 utf8_general_ci NULL 654def mtr latin1 latin1_swedish_ci NULL 655def mysql latin1 latin1_swedish_ci NULL 656def performance_schema utf8 utf8_general_ci NULL 657def test latin1 latin1_swedish_ci NULL 658ALTER DATABASE d10 DEFAULT COLLATE utf8_estonian_ci; 659SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 660CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 661def d10 utf8 utf8_estonian_ci NULL 662def information_schema utf8 utf8_general_ci NULL 663def mtr latin1 latin1_swedish_ci NULL 664def mysql latin1 latin1_swedish_ci NULL 665def performance_schema utf8 utf8_general_ci NULL 666def test latin1 latin1_swedish_ci NULL 667DROP DATABASE d10; 668CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 669SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 670CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 671def d10 utf8 utf8_general_ci NULL 672def information_schema utf8 utf8_general_ci NULL 673def mtr latin1 latin1_swedish_ci NULL 674def mysql latin1 latin1_swedish_ci NULL 675def performance_schema utf8 utf8_general_ci NULL 676def test latin1 latin1_swedish_ci NULL 677ALTER DATABASE d10 COLLATE utf8_spanish_ci; 678SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 679CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 680def d10 utf8 utf8_spanish_ci NULL 681def information_schema utf8 utf8_general_ci NULL 682def mtr latin1 latin1_swedish_ci NULL 683def mysql latin1 latin1_swedish_ci NULL 684def performance_schema utf8 utf8_general_ci NULL 685def test latin1 latin1_swedish_ci NULL 686DROP DATABASE d10; 687CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 688SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 689CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 690def d10 utf8 utf8_general_ci NULL 691def information_schema utf8 utf8_general_ci NULL 692def mtr latin1 latin1_swedish_ci NULL 693def mysql latin1 latin1_swedish_ci NULL 694def performance_schema utf8 utf8_general_ci NULL 695def test latin1 latin1_swedish_ci NULL 696ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish_ci; 697SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 698CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 699def d10 utf8 utf8_spanish_ci NULL 700def information_schema utf8 utf8_general_ci NULL 701def mtr latin1 latin1_swedish_ci NULL 702def mysql latin1 latin1_swedish_ci NULL 703def performance_schema utf8 utf8_general_ci NULL 704def test latin1 latin1_swedish_ci NULL 705DROP DATABASE d10; 706CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 707SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 708CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 709def d10 utf8 utf8_general_ci NULL 710def information_schema utf8 utf8_general_ci NULL 711def mtr latin1 latin1_swedish_ci NULL 712def mysql latin1 latin1_swedish_ci NULL 713def performance_schema utf8 utf8_general_ci NULL 714def test latin1 latin1_swedish_ci NULL 715ALTER DATABASE d10 COLLATE utf8_swedish_ci; 716SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 717CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 718def d10 utf8 utf8_swedish_ci NULL 719def information_schema utf8 utf8_general_ci NULL 720def mtr latin1 latin1_swedish_ci NULL 721def mysql latin1 latin1_swedish_ci NULL 722def performance_schema utf8 utf8_general_ci NULL 723def test latin1 latin1_swedish_ci NULL 724DROP DATABASE d10; 725CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 726SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 727CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 728def d10 utf8 utf8_general_ci NULL 729def information_schema utf8 utf8_general_ci NULL 730def mtr latin1 latin1_swedish_ci NULL 731def mysql latin1 latin1_swedish_ci NULL 732def performance_schema utf8 utf8_general_ci NULL 733def test latin1 latin1_swedish_ci NULL 734ALTER DATABASE d10 DEFAULT COLLATE utf8_swedish_ci; 735SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 736CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 737def d10 utf8 utf8_swedish_ci NULL 738def information_schema utf8 utf8_general_ci NULL 739def mtr latin1 latin1_swedish_ci NULL 740def mysql latin1 latin1_swedish_ci NULL 741def performance_schema utf8 utf8_general_ci NULL 742def test latin1 latin1_swedish_ci NULL 743DROP DATABASE d10; 744CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 745SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 746CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 747def d10 utf8 utf8_general_ci NULL 748def information_schema utf8 utf8_general_ci NULL 749def mtr latin1 latin1_swedish_ci NULL 750def mysql latin1 latin1_swedish_ci NULL 751def performance_schema utf8 utf8_general_ci NULL 752def test latin1 latin1_swedish_ci NULL 753ALTER DATABASE d10 COLLATE utf8_turkish_ci; 754SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 755CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 756def d10 utf8 utf8_turkish_ci NULL 757def information_schema utf8 utf8_general_ci NULL 758def mtr latin1 latin1_swedish_ci NULL 759def mysql latin1 latin1_swedish_ci NULL 760def performance_schema utf8 utf8_general_ci NULL 761def test latin1 latin1_swedish_ci NULL 762DROP DATABASE d10; 763CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 764SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 765CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 766def d10 utf8 utf8_general_ci NULL 767def information_schema utf8 utf8_general_ci NULL 768def mtr latin1 latin1_swedish_ci NULL 769def mysql latin1 latin1_swedish_ci NULL 770def performance_schema utf8 utf8_general_ci NULL 771def test latin1 latin1_swedish_ci NULL 772ALTER DATABASE d10 DEFAULT COLLATE utf8_turkish_ci; 773SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 774CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 775def d10 utf8 utf8_turkish_ci NULL 776def information_schema utf8 utf8_general_ci NULL 777def mtr latin1 latin1_swedish_ci NULL 778def mysql latin1 latin1_swedish_ci NULL 779def performance_schema utf8 utf8_general_ci NULL 780def test latin1 latin1_swedish_ci NULL 781DROP DATABASE d10; 782CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 783SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 784CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 785def d10 utf8 utf8_general_ci NULL 786def information_schema utf8 utf8_general_ci NULL 787def mtr latin1 latin1_swedish_ci NULL 788def mysql latin1 latin1_swedish_ci NULL 789def performance_schema utf8 utf8_general_ci NULL 790def test latin1 latin1_swedish_ci NULL 791ALTER DATABASE d10 COLLATE utf8_czech_ci; 792SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 793CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 794def d10 utf8 utf8_czech_ci NULL 795def information_schema utf8 utf8_general_ci NULL 796def mtr latin1 latin1_swedish_ci NULL 797def mysql latin1 latin1_swedish_ci NULL 798def performance_schema utf8 utf8_general_ci NULL 799def test latin1 latin1_swedish_ci NULL 800DROP DATABASE d10; 801CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 802SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 803CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 804def d10 utf8 utf8_general_ci NULL 805def information_schema utf8 utf8_general_ci NULL 806def mtr latin1 latin1_swedish_ci NULL 807def mysql latin1 latin1_swedish_ci NULL 808def performance_schema utf8 utf8_general_ci NULL 809def test latin1 latin1_swedish_ci NULL 810ALTER DATABASE d10 DEFAULT COLLATE utf8_czech_ci; 811SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 812CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 813def d10 utf8 utf8_czech_ci NULL 814def information_schema utf8 utf8_general_ci NULL 815def mtr latin1 latin1_swedish_ci NULL 816def mysql latin1 latin1_swedish_ci NULL 817def performance_schema utf8 utf8_general_ci NULL 818def test latin1 latin1_swedish_ci NULL 819DROP DATABASE d10; 820CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 821SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 822CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 823def d10 utf8 utf8_general_ci NULL 824def information_schema utf8 utf8_general_ci NULL 825def mtr latin1 latin1_swedish_ci NULL 826def mysql latin1 latin1_swedish_ci NULL 827def performance_schema utf8 utf8_general_ci NULL 828def test latin1 latin1_swedish_ci NULL 829ALTER DATABASE d10 COLLATE utf8_danish_ci; 830SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 831CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 832def d10 utf8 utf8_danish_ci NULL 833def information_schema utf8 utf8_general_ci NULL 834def mtr latin1 latin1_swedish_ci NULL 835def mysql latin1 latin1_swedish_ci NULL 836def performance_schema utf8 utf8_general_ci NULL 837def test latin1 latin1_swedish_ci NULL 838DROP DATABASE d10; 839CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 840SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 841CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 842def d10 utf8 utf8_general_ci NULL 843def information_schema utf8 utf8_general_ci NULL 844def mtr latin1 latin1_swedish_ci NULL 845def mysql latin1 latin1_swedish_ci NULL 846def performance_schema utf8 utf8_general_ci NULL 847def test latin1 latin1_swedish_ci NULL 848ALTER DATABASE d10 DEFAULT COLLATE utf8_danish_ci; 849SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 850CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 851def d10 utf8 utf8_danish_ci NULL 852def information_schema utf8 utf8_general_ci NULL 853def mtr latin1 latin1_swedish_ci NULL 854def mysql latin1 latin1_swedish_ci NULL 855def performance_schema utf8 utf8_general_ci NULL 856def test latin1 latin1_swedish_ci NULL 857DROP DATABASE d10; 858CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 859SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 860CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 861def d10 utf8 utf8_general_ci NULL 862def information_schema utf8 utf8_general_ci NULL 863def mtr latin1 latin1_swedish_ci NULL 864def mysql latin1 latin1_swedish_ci NULL 865def performance_schema utf8 utf8_general_ci NULL 866def test latin1 latin1_swedish_ci NULL 867ALTER DATABASE d10 COLLATE utf8_lithuanian_ci; 868SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 869CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 870def d10 utf8 utf8_lithuanian_ci NULL 871def information_schema utf8 utf8_general_ci NULL 872def mtr latin1 latin1_swedish_ci NULL 873def mysql latin1 latin1_swedish_ci NULL 874def performance_schema utf8 utf8_general_ci NULL 875def test latin1 latin1_swedish_ci NULL 876DROP DATABASE d10; 877CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 878SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 879CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 880def d10 utf8 utf8_general_ci NULL 881def information_schema utf8 utf8_general_ci NULL 882def mtr latin1 latin1_swedish_ci NULL 883def mysql latin1 latin1_swedish_ci NULL 884def performance_schema utf8 utf8_general_ci NULL 885def test latin1 latin1_swedish_ci NULL 886ALTER DATABASE d10 DEFAULT COLLATE utf8_lithuanian_ci; 887SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 888CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 889def d10 utf8 utf8_lithuanian_ci NULL 890def information_schema utf8 utf8_general_ci NULL 891def mtr latin1 latin1_swedish_ci NULL 892def mysql latin1 latin1_swedish_ci NULL 893def performance_schema utf8 utf8_general_ci NULL 894def test latin1 latin1_swedish_ci NULL 895DROP DATABASE d10; 896CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 897SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 898CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 899def d10 utf8 utf8_general_ci NULL 900def information_schema utf8 utf8_general_ci NULL 901def mtr latin1 latin1_swedish_ci NULL 902def mysql latin1 latin1_swedish_ci NULL 903def performance_schema utf8 utf8_general_ci NULL 904def test latin1 latin1_swedish_ci NULL 905ALTER DATABASE d10 COLLATE utf8_slovak_ci; 906SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 907CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 908def d10 utf8 utf8_slovak_ci NULL 909def information_schema utf8 utf8_general_ci NULL 910def mtr latin1 latin1_swedish_ci NULL 911def mysql latin1 latin1_swedish_ci NULL 912def performance_schema utf8 utf8_general_ci NULL 913def test latin1 latin1_swedish_ci NULL 914DROP DATABASE d10; 915CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 916SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 917CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 918def d10 utf8 utf8_general_ci NULL 919def information_schema utf8 utf8_general_ci NULL 920def mtr latin1 latin1_swedish_ci NULL 921def mysql latin1 latin1_swedish_ci NULL 922def performance_schema utf8 utf8_general_ci NULL 923def test latin1 latin1_swedish_ci NULL 924ALTER DATABASE d10 DEFAULT COLLATE utf8_slovak_ci; 925SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 926CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 927def d10 utf8 utf8_slovak_ci NULL 928def information_schema utf8 utf8_general_ci NULL 929def mtr latin1 latin1_swedish_ci NULL 930def mysql latin1 latin1_swedish_ci NULL 931def performance_schema utf8 utf8_general_ci NULL 932def test latin1 latin1_swedish_ci NULL 933DROP DATABASE d10; 934CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 935SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 936CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 937def d10 utf8 utf8_general_ci NULL 938def information_schema utf8 utf8_general_ci NULL 939def mtr latin1 latin1_swedish_ci NULL 940def mysql latin1 latin1_swedish_ci NULL 941def performance_schema utf8 utf8_general_ci NULL 942def test latin1 latin1_swedish_ci NULL 943ALTER DATABASE d10 COLLATE utf8_spanish2_ci; 944SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 945CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 946def d10 utf8 utf8_spanish2_ci NULL 947def information_schema utf8 utf8_general_ci NULL 948def mtr latin1 latin1_swedish_ci NULL 949def mysql latin1 latin1_swedish_ci NULL 950def performance_schema utf8 utf8_general_ci NULL 951def test latin1 latin1_swedish_ci NULL 952DROP DATABASE d10; 953CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 954SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 955CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 956def d10 utf8 utf8_general_ci NULL 957def information_schema utf8 utf8_general_ci NULL 958def mtr latin1 latin1_swedish_ci NULL 959def mysql latin1 latin1_swedish_ci NULL 960def performance_schema utf8 utf8_general_ci NULL 961def test latin1 latin1_swedish_ci NULL 962ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish2_ci; 963SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 964CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 965def d10 utf8 utf8_spanish2_ci NULL 966def information_schema utf8 utf8_general_ci NULL 967def mtr latin1 latin1_swedish_ci NULL 968def mysql latin1 latin1_swedish_ci NULL 969def performance_schema utf8 utf8_general_ci NULL 970def test latin1 latin1_swedish_ci NULL 971DROP DATABASE d10; 972CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 973SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 974CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 975def d10 utf8 utf8_general_ci NULL 976def information_schema utf8 utf8_general_ci NULL 977def mtr latin1 latin1_swedish_ci NULL 978def mysql latin1 latin1_swedish_ci NULL 979def performance_schema utf8 utf8_general_ci NULL 980def test latin1 latin1_swedish_ci NULL 981ALTER DATABASE d10 COLLATE utf8_roman_ci; 982SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 983CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 984def d10 utf8 utf8_roman_ci NULL 985def information_schema utf8 utf8_general_ci NULL 986def mtr latin1 latin1_swedish_ci NULL 987def mysql latin1 latin1_swedish_ci NULL 988def performance_schema utf8 utf8_general_ci NULL 989def test latin1 latin1_swedish_ci NULL 990DROP DATABASE d10; 991CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 992SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 993CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 994def d10 utf8 utf8_general_ci NULL 995def information_schema utf8 utf8_general_ci NULL 996def mtr latin1 latin1_swedish_ci NULL 997def mysql latin1 latin1_swedish_ci NULL 998def performance_schema utf8 utf8_general_ci NULL 999def test latin1 latin1_swedish_ci NULL 1000ALTER DATABASE d10 DEFAULT COLLATE utf8_roman_ci; 1001SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1002CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1003def d10 utf8 utf8_roman_ci NULL 1004def information_schema utf8 utf8_general_ci NULL 1005def mtr latin1 latin1_swedish_ci NULL 1006def mysql latin1 latin1_swedish_ci NULL 1007def performance_schema utf8 utf8_general_ci NULL 1008def test latin1 latin1_swedish_ci NULL 1009DROP DATABASE d10; 1010CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1011SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1012CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1013def d10 utf8 utf8_general_ci NULL 1014def information_schema utf8 utf8_general_ci NULL 1015def mtr latin1 latin1_swedish_ci NULL 1016def mysql latin1 latin1_swedish_ci NULL 1017def performance_schema utf8 utf8_general_ci NULL 1018def test latin1 latin1_swedish_ci NULL 1019ALTER DATABASE d10 COLLATE utf8_persian_ci; 1020SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1021CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1022def d10 utf8 utf8_persian_ci NULL 1023def information_schema utf8 utf8_general_ci NULL 1024def mtr latin1 latin1_swedish_ci NULL 1025def mysql latin1 latin1_swedish_ci NULL 1026def performance_schema utf8 utf8_general_ci NULL 1027def test latin1 latin1_swedish_ci NULL 1028DROP DATABASE d10; 1029CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1030SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1031CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1032def d10 utf8 utf8_general_ci NULL 1033def information_schema utf8 utf8_general_ci NULL 1034def mtr latin1 latin1_swedish_ci NULL 1035def mysql latin1 latin1_swedish_ci NULL 1036def performance_schema utf8 utf8_general_ci NULL 1037def test latin1 latin1_swedish_ci NULL 1038ALTER DATABASE d10 DEFAULT COLLATE utf8_persian_ci; 1039SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1040CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1041def d10 utf8 utf8_persian_ci NULL 1042def information_schema utf8 utf8_general_ci NULL 1043def mtr latin1 latin1_swedish_ci NULL 1044def mysql latin1 latin1_swedish_ci NULL 1045def performance_schema utf8 utf8_general_ci NULL 1046def test latin1 latin1_swedish_ci NULL 1047DROP DATABASE d10; 1048CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1049SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1050CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1051def d10 utf8 utf8_general_ci NULL 1052def information_schema utf8 utf8_general_ci NULL 1053def mtr latin1 latin1_swedish_ci NULL 1054def mysql latin1 latin1_swedish_ci NULL 1055def performance_schema utf8 utf8_general_ci NULL 1056def test latin1 latin1_swedish_ci NULL 1057ALTER DATABASE d10 COLLATE utf8_esperanto_ci; 1058SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1059CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1060def d10 utf8 utf8_esperanto_ci NULL 1061def information_schema utf8 utf8_general_ci NULL 1062def mtr latin1 latin1_swedish_ci NULL 1063def mysql latin1 latin1_swedish_ci NULL 1064def performance_schema utf8 utf8_general_ci NULL 1065def test latin1 latin1_swedish_ci NULL 1066DROP DATABASE d10; 1067CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1068SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1069CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1070def d10 utf8 utf8_general_ci NULL 1071def information_schema utf8 utf8_general_ci NULL 1072def mtr latin1 latin1_swedish_ci NULL 1073def mysql latin1 latin1_swedish_ci NULL 1074def performance_schema utf8 utf8_general_ci NULL 1075def test latin1 latin1_swedish_ci NULL 1076ALTER DATABASE d10 DEFAULT COLLATE utf8_esperanto_ci; 1077SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1078CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1079def d10 utf8 utf8_esperanto_ci NULL 1080def information_schema utf8 utf8_general_ci NULL 1081def mtr latin1 latin1_swedish_ci NULL 1082def mysql latin1 latin1_swedish_ci NULL 1083def performance_schema utf8 utf8_general_ci NULL 1084def test latin1 latin1_swedish_ci NULL 1085DROP DATABASE d10; 1086CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1087SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1088CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1089def d10 utf8 utf8_general_ci NULL 1090def information_schema utf8 utf8_general_ci NULL 1091def mtr latin1 latin1_swedish_ci NULL 1092def mysql latin1 latin1_swedish_ci NULL 1093def performance_schema utf8 utf8_general_ci NULL 1094def test latin1 latin1_swedish_ci NULL 1095ALTER DATABASE d10 COLLATE utf8_hungarian_ci; 1096SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1097CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1098def d10 utf8 utf8_hungarian_ci NULL 1099def information_schema utf8 utf8_general_ci NULL 1100def mtr latin1 latin1_swedish_ci NULL 1101def mysql latin1 latin1_swedish_ci NULL 1102def performance_schema utf8 utf8_general_ci NULL 1103def test latin1 latin1_swedish_ci NULL 1104DROP DATABASE d10; 1105CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1106SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1107CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1108def d10 utf8 utf8_general_ci NULL 1109def information_schema utf8 utf8_general_ci NULL 1110def mtr latin1 latin1_swedish_ci NULL 1111def mysql latin1 latin1_swedish_ci NULL 1112def performance_schema utf8 utf8_general_ci NULL 1113def test latin1 latin1_swedish_ci NULL 1114ALTER DATABASE d10 DEFAULT COLLATE utf8_hungarian_ci; 1115SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1116CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1117def d10 utf8 utf8_hungarian_ci NULL 1118def information_schema utf8 utf8_general_ci NULL 1119def mtr latin1 latin1_swedish_ci NULL 1120def mysql latin1 latin1_swedish_ci NULL 1121def performance_schema utf8 utf8_general_ci NULL 1122def test latin1 latin1_swedish_ci NULL 1123DROP DATABASE d10; 1124CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1125SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1126CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1127def d10 utf8 utf8_general_ci NULL 1128def information_schema utf8 utf8_general_ci NULL 1129def mtr latin1 latin1_swedish_ci NULL 1130def mysql latin1 latin1_swedish_ci NULL 1131def performance_schema utf8 utf8_general_ci NULL 1132def test latin1 latin1_swedish_ci NULL 1133ALTER SCHEMA d10 COLLATE utf8_general_ci; 1134SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1135CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1136def d10 utf8 utf8_general_ci NULL 1137def information_schema utf8 utf8_general_ci NULL 1138def mtr latin1 latin1_swedish_ci NULL 1139def mysql latin1 latin1_swedish_ci NULL 1140def performance_schema utf8 utf8_general_ci NULL 1141def test latin1 latin1_swedish_ci NULL 1142DROP DATABASE d10; 1143CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1144SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1145CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1146def d10 utf8 utf8_general_ci NULL 1147def information_schema utf8 utf8_general_ci NULL 1148def mtr latin1 latin1_swedish_ci NULL 1149def mysql latin1 latin1_swedish_ci NULL 1150def performance_schema utf8 utf8_general_ci NULL 1151def test latin1 latin1_swedish_ci NULL 1152ALTER SCHEMA d10 DEFAULT COLLATE utf8_general_ci; 1153SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1154CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1155def d10 utf8 utf8_general_ci NULL 1156def information_schema utf8 utf8_general_ci NULL 1157def mtr latin1 latin1_swedish_ci NULL 1158def mysql latin1 latin1_swedish_ci NULL 1159def performance_schema utf8 utf8_general_ci NULL 1160def test latin1 latin1_swedish_ci NULL 1161DROP DATABASE d10; 1162CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1163SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1164CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1165def d10 utf8 utf8_general_ci NULL 1166def information_schema utf8 utf8_general_ci NULL 1167def mtr latin1 latin1_swedish_ci NULL 1168def mysql latin1 latin1_swedish_ci NULL 1169def performance_schema utf8 utf8_general_ci NULL 1170def test latin1 latin1_swedish_ci NULL 1171ALTER SCHEMA d10 COLLATE utf8_bin; 1172SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1173CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1174def d10 utf8 utf8_bin NULL 1175def information_schema utf8 utf8_general_ci NULL 1176def mtr latin1 latin1_swedish_ci NULL 1177def mysql latin1 latin1_swedish_ci NULL 1178def performance_schema utf8 utf8_general_ci NULL 1179def test latin1 latin1_swedish_ci NULL 1180DROP DATABASE d10; 1181CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1182SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1183CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1184def d10 utf8 utf8_general_ci NULL 1185def information_schema utf8 utf8_general_ci NULL 1186def mtr latin1 latin1_swedish_ci NULL 1187def mysql latin1 latin1_swedish_ci NULL 1188def performance_schema utf8 utf8_general_ci NULL 1189def test latin1 latin1_swedish_ci NULL 1190ALTER SCHEMA d10 DEFAULT COLLATE utf8_bin; 1191SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1192CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1193def d10 utf8 utf8_bin NULL 1194def information_schema utf8 utf8_general_ci NULL 1195def mtr latin1 latin1_swedish_ci NULL 1196def mysql latin1 latin1_swedish_ci NULL 1197def performance_schema utf8 utf8_general_ci NULL 1198def test latin1 latin1_swedish_ci NULL 1199DROP DATABASE d10; 1200CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1201SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1202CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1203def d10 utf8 utf8_general_ci NULL 1204def information_schema utf8 utf8_general_ci NULL 1205def mtr latin1 latin1_swedish_ci NULL 1206def mysql latin1 latin1_swedish_ci NULL 1207def performance_schema utf8 utf8_general_ci NULL 1208def test latin1 latin1_swedish_ci NULL 1209ALTER SCHEMA d10 COLLATE utf8_unicode_ci; 1210SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1211CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1212def d10 utf8 utf8_unicode_ci NULL 1213def information_schema utf8 utf8_general_ci NULL 1214def mtr latin1 latin1_swedish_ci NULL 1215def mysql latin1 latin1_swedish_ci NULL 1216def performance_schema utf8 utf8_general_ci NULL 1217def test latin1 latin1_swedish_ci NULL 1218DROP DATABASE d10; 1219CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1220SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1221CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1222def d10 utf8 utf8_general_ci NULL 1223def information_schema utf8 utf8_general_ci NULL 1224def mtr latin1 latin1_swedish_ci NULL 1225def mysql latin1 latin1_swedish_ci NULL 1226def performance_schema utf8 utf8_general_ci NULL 1227def test latin1 latin1_swedish_ci NULL 1228ALTER SCHEMA d10 DEFAULT COLLATE utf8_unicode_ci; 1229SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1230CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1231def d10 utf8 utf8_unicode_ci NULL 1232def information_schema utf8 utf8_general_ci NULL 1233def mtr latin1 latin1_swedish_ci NULL 1234def mysql latin1 latin1_swedish_ci NULL 1235def performance_schema utf8 utf8_general_ci NULL 1236def test latin1 latin1_swedish_ci NULL 1237DROP DATABASE d10; 1238CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1239SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1240CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1241def d10 utf8 utf8_general_ci NULL 1242def information_schema utf8 utf8_general_ci NULL 1243def mtr latin1 latin1_swedish_ci NULL 1244def mysql latin1 latin1_swedish_ci NULL 1245def performance_schema utf8 utf8_general_ci NULL 1246def test latin1 latin1_swedish_ci NULL 1247ALTER SCHEMA d10 COLLATE utf8_icelandic_ci; 1248SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1249CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1250def d10 utf8 utf8_icelandic_ci NULL 1251def information_schema utf8 utf8_general_ci NULL 1252def mtr latin1 latin1_swedish_ci NULL 1253def mysql latin1 latin1_swedish_ci NULL 1254def performance_schema utf8 utf8_general_ci NULL 1255def test latin1 latin1_swedish_ci NULL 1256DROP DATABASE d10; 1257CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1258SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1259CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1260def d10 utf8 utf8_general_ci NULL 1261def information_schema utf8 utf8_general_ci NULL 1262def mtr latin1 latin1_swedish_ci NULL 1263def mysql latin1 latin1_swedish_ci NULL 1264def performance_schema utf8 utf8_general_ci NULL 1265def test latin1 latin1_swedish_ci NULL 1266ALTER SCHEMA d10 DEFAULT COLLATE utf8_icelandic_ci; 1267SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1268CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1269def d10 utf8 utf8_icelandic_ci NULL 1270def information_schema utf8 utf8_general_ci NULL 1271def mtr latin1 latin1_swedish_ci NULL 1272def mysql latin1 latin1_swedish_ci NULL 1273def performance_schema utf8 utf8_general_ci NULL 1274def test latin1 latin1_swedish_ci NULL 1275DROP DATABASE d10; 1276CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1277SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1278CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1279def d10 utf8 utf8_general_ci NULL 1280def information_schema utf8 utf8_general_ci NULL 1281def mtr latin1 latin1_swedish_ci NULL 1282def mysql latin1 latin1_swedish_ci NULL 1283def performance_schema utf8 utf8_general_ci NULL 1284def test latin1 latin1_swedish_ci NULL 1285ALTER SCHEMA d10 COLLATE utf8_latvian_ci; 1286SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1287CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1288def d10 utf8 utf8_latvian_ci NULL 1289def information_schema utf8 utf8_general_ci NULL 1290def mtr latin1 latin1_swedish_ci NULL 1291def mysql latin1 latin1_swedish_ci NULL 1292def performance_schema utf8 utf8_general_ci NULL 1293def test latin1 latin1_swedish_ci NULL 1294DROP DATABASE d10; 1295CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1296SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1297CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1298def d10 utf8 utf8_general_ci NULL 1299def information_schema utf8 utf8_general_ci NULL 1300def mtr latin1 latin1_swedish_ci NULL 1301def mysql latin1 latin1_swedish_ci NULL 1302def performance_schema utf8 utf8_general_ci NULL 1303def test latin1 latin1_swedish_ci NULL 1304ALTER SCHEMA d10 DEFAULT COLLATE utf8_latvian_ci; 1305SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1306CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1307def d10 utf8 utf8_latvian_ci NULL 1308def information_schema utf8 utf8_general_ci NULL 1309def mtr latin1 latin1_swedish_ci NULL 1310def mysql latin1 latin1_swedish_ci NULL 1311def performance_schema utf8 utf8_general_ci NULL 1312def test latin1 latin1_swedish_ci NULL 1313DROP DATABASE d10; 1314CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1315SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1316CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1317def d10 utf8 utf8_general_ci NULL 1318def information_schema utf8 utf8_general_ci NULL 1319def mtr latin1 latin1_swedish_ci NULL 1320def mysql latin1 latin1_swedish_ci NULL 1321def performance_schema utf8 utf8_general_ci NULL 1322def test latin1 latin1_swedish_ci NULL 1323ALTER SCHEMA d10 COLLATE utf8_romanian_ci; 1324SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1325CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1326def d10 utf8 utf8_romanian_ci NULL 1327def information_schema utf8 utf8_general_ci NULL 1328def mtr latin1 latin1_swedish_ci NULL 1329def mysql latin1 latin1_swedish_ci NULL 1330def performance_schema utf8 utf8_general_ci NULL 1331def test latin1 latin1_swedish_ci NULL 1332DROP DATABASE d10; 1333CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1334SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1335CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1336def d10 utf8 utf8_general_ci NULL 1337def information_schema utf8 utf8_general_ci NULL 1338def mtr latin1 latin1_swedish_ci NULL 1339def mysql latin1 latin1_swedish_ci NULL 1340def performance_schema utf8 utf8_general_ci NULL 1341def test latin1 latin1_swedish_ci NULL 1342ALTER SCHEMA d10 DEFAULT COLLATE utf8_romanian_ci; 1343SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1344CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1345def d10 utf8 utf8_romanian_ci NULL 1346def information_schema utf8 utf8_general_ci NULL 1347def mtr latin1 latin1_swedish_ci NULL 1348def mysql latin1 latin1_swedish_ci NULL 1349def performance_schema utf8 utf8_general_ci NULL 1350def test latin1 latin1_swedish_ci NULL 1351DROP DATABASE d10; 1352CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1353SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1354CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1355def d10 utf8 utf8_general_ci NULL 1356def information_schema utf8 utf8_general_ci NULL 1357def mtr latin1 latin1_swedish_ci NULL 1358def mysql latin1 latin1_swedish_ci NULL 1359def performance_schema utf8 utf8_general_ci NULL 1360def test latin1 latin1_swedish_ci NULL 1361ALTER SCHEMA d10 COLLATE utf8_slovenian_ci; 1362SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1363CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1364def d10 utf8 utf8_slovenian_ci NULL 1365def information_schema utf8 utf8_general_ci NULL 1366def mtr latin1 latin1_swedish_ci NULL 1367def mysql latin1 latin1_swedish_ci NULL 1368def performance_schema utf8 utf8_general_ci NULL 1369def test latin1 latin1_swedish_ci NULL 1370DROP DATABASE d10; 1371CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1372SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1373CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1374def d10 utf8 utf8_general_ci NULL 1375def information_schema utf8 utf8_general_ci NULL 1376def mtr latin1 latin1_swedish_ci NULL 1377def mysql latin1 latin1_swedish_ci NULL 1378def performance_schema utf8 utf8_general_ci NULL 1379def test latin1 latin1_swedish_ci NULL 1380ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovenian_ci; 1381SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1382CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1383def d10 utf8 utf8_slovenian_ci NULL 1384def information_schema utf8 utf8_general_ci NULL 1385def mtr latin1 latin1_swedish_ci NULL 1386def mysql latin1 latin1_swedish_ci NULL 1387def performance_schema utf8 utf8_general_ci NULL 1388def test latin1 latin1_swedish_ci NULL 1389DROP DATABASE d10; 1390CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1391SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1392CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1393def d10 utf8 utf8_general_ci NULL 1394def information_schema utf8 utf8_general_ci NULL 1395def mtr latin1 latin1_swedish_ci NULL 1396def mysql latin1 latin1_swedish_ci NULL 1397def performance_schema utf8 utf8_general_ci NULL 1398def test latin1 latin1_swedish_ci NULL 1399ALTER SCHEMA d10 COLLATE utf8_polish_ci; 1400SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1401CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1402def d10 utf8 utf8_polish_ci NULL 1403def information_schema utf8 utf8_general_ci NULL 1404def mtr latin1 latin1_swedish_ci NULL 1405def mysql latin1 latin1_swedish_ci NULL 1406def performance_schema utf8 utf8_general_ci NULL 1407def test latin1 latin1_swedish_ci NULL 1408DROP DATABASE d10; 1409CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1410SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1411CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1412def d10 utf8 utf8_general_ci NULL 1413def information_schema utf8 utf8_general_ci NULL 1414def mtr latin1 latin1_swedish_ci NULL 1415def mysql latin1 latin1_swedish_ci NULL 1416def performance_schema utf8 utf8_general_ci NULL 1417def test latin1 latin1_swedish_ci NULL 1418ALTER SCHEMA d10 DEFAULT COLLATE utf8_polish_ci; 1419SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1420CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1421def d10 utf8 utf8_polish_ci NULL 1422def information_schema utf8 utf8_general_ci NULL 1423def mtr latin1 latin1_swedish_ci NULL 1424def mysql latin1 latin1_swedish_ci NULL 1425def performance_schema utf8 utf8_general_ci NULL 1426def test latin1 latin1_swedish_ci NULL 1427DROP DATABASE d10; 1428CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1429SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1430CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1431def d10 utf8 utf8_general_ci NULL 1432def information_schema utf8 utf8_general_ci NULL 1433def mtr latin1 latin1_swedish_ci NULL 1434def mysql latin1 latin1_swedish_ci NULL 1435def performance_schema utf8 utf8_general_ci NULL 1436def test latin1 latin1_swedish_ci NULL 1437ALTER SCHEMA d10 COLLATE utf8_estonian_ci; 1438SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1439CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1440def d10 utf8 utf8_estonian_ci NULL 1441def information_schema utf8 utf8_general_ci NULL 1442def mtr latin1 latin1_swedish_ci NULL 1443def mysql latin1 latin1_swedish_ci NULL 1444def performance_schema utf8 utf8_general_ci NULL 1445def test latin1 latin1_swedish_ci NULL 1446DROP DATABASE d10; 1447CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1448SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1449CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1450def d10 utf8 utf8_general_ci NULL 1451def information_schema utf8 utf8_general_ci NULL 1452def mtr latin1 latin1_swedish_ci NULL 1453def mysql latin1 latin1_swedish_ci NULL 1454def performance_schema utf8 utf8_general_ci NULL 1455def test latin1 latin1_swedish_ci NULL 1456ALTER SCHEMA d10 DEFAULT COLLATE utf8_estonian_ci; 1457SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1458CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1459def d10 utf8 utf8_estonian_ci NULL 1460def information_schema utf8 utf8_general_ci NULL 1461def mtr latin1 latin1_swedish_ci NULL 1462def mysql latin1 latin1_swedish_ci NULL 1463def performance_schema utf8 utf8_general_ci NULL 1464def test latin1 latin1_swedish_ci NULL 1465DROP DATABASE d10; 1466CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1467SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1468CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1469def d10 utf8 utf8_general_ci NULL 1470def information_schema utf8 utf8_general_ci NULL 1471def mtr latin1 latin1_swedish_ci NULL 1472def mysql latin1 latin1_swedish_ci NULL 1473def performance_schema utf8 utf8_general_ci NULL 1474def test latin1 latin1_swedish_ci NULL 1475ALTER SCHEMA d10 COLLATE utf8_spanish_ci; 1476SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1477CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1478def d10 utf8 utf8_spanish_ci NULL 1479def information_schema utf8 utf8_general_ci NULL 1480def mtr latin1 latin1_swedish_ci NULL 1481def mysql latin1 latin1_swedish_ci NULL 1482def performance_schema utf8 utf8_general_ci NULL 1483def test latin1 latin1_swedish_ci NULL 1484DROP DATABASE d10; 1485CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1486SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1487CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1488def d10 utf8 utf8_general_ci NULL 1489def information_schema utf8 utf8_general_ci NULL 1490def mtr latin1 latin1_swedish_ci NULL 1491def mysql latin1 latin1_swedish_ci NULL 1492def performance_schema utf8 utf8_general_ci NULL 1493def test latin1 latin1_swedish_ci NULL 1494ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish_ci; 1495SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1496CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1497def d10 utf8 utf8_spanish_ci NULL 1498def information_schema utf8 utf8_general_ci NULL 1499def mtr latin1 latin1_swedish_ci NULL 1500def mysql latin1 latin1_swedish_ci NULL 1501def performance_schema utf8 utf8_general_ci NULL 1502def test latin1 latin1_swedish_ci NULL 1503DROP DATABASE d10; 1504CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1505SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1506CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1507def d10 utf8 utf8_general_ci NULL 1508def information_schema utf8 utf8_general_ci NULL 1509def mtr latin1 latin1_swedish_ci NULL 1510def mysql latin1 latin1_swedish_ci NULL 1511def performance_schema utf8 utf8_general_ci NULL 1512def test latin1 latin1_swedish_ci NULL 1513ALTER SCHEMA d10 COLLATE utf8_swedish_ci; 1514SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1515CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1516def d10 utf8 utf8_swedish_ci NULL 1517def information_schema utf8 utf8_general_ci NULL 1518def mtr latin1 latin1_swedish_ci NULL 1519def mysql latin1 latin1_swedish_ci NULL 1520def performance_schema utf8 utf8_general_ci NULL 1521def test latin1 latin1_swedish_ci NULL 1522DROP DATABASE d10; 1523CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1524SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1525CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1526def d10 utf8 utf8_general_ci NULL 1527def information_schema utf8 utf8_general_ci NULL 1528def mtr latin1 latin1_swedish_ci NULL 1529def mysql latin1 latin1_swedish_ci NULL 1530def performance_schema utf8 utf8_general_ci NULL 1531def test latin1 latin1_swedish_ci NULL 1532ALTER SCHEMA d10 DEFAULT COLLATE utf8_swedish_ci; 1533SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1534CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1535def d10 utf8 utf8_swedish_ci NULL 1536def information_schema utf8 utf8_general_ci NULL 1537def mtr latin1 latin1_swedish_ci NULL 1538def mysql latin1 latin1_swedish_ci NULL 1539def performance_schema utf8 utf8_general_ci NULL 1540def test latin1 latin1_swedish_ci NULL 1541DROP DATABASE d10; 1542CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1543SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1544CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1545def d10 utf8 utf8_general_ci NULL 1546def information_schema utf8 utf8_general_ci NULL 1547def mtr latin1 latin1_swedish_ci NULL 1548def mysql latin1 latin1_swedish_ci NULL 1549def performance_schema utf8 utf8_general_ci NULL 1550def test latin1 latin1_swedish_ci NULL 1551ALTER SCHEMA d10 COLLATE utf8_turkish_ci; 1552SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1553CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1554def d10 utf8 utf8_turkish_ci NULL 1555def information_schema utf8 utf8_general_ci NULL 1556def mtr latin1 latin1_swedish_ci NULL 1557def mysql latin1 latin1_swedish_ci NULL 1558def performance_schema utf8 utf8_general_ci NULL 1559def test latin1 latin1_swedish_ci NULL 1560DROP DATABASE d10; 1561CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1562SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1563CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1564def d10 utf8 utf8_general_ci NULL 1565def information_schema utf8 utf8_general_ci NULL 1566def mtr latin1 latin1_swedish_ci NULL 1567def mysql latin1 latin1_swedish_ci NULL 1568def performance_schema utf8 utf8_general_ci NULL 1569def test latin1 latin1_swedish_ci NULL 1570ALTER SCHEMA d10 DEFAULT COLLATE utf8_turkish_ci; 1571SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1572CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1573def d10 utf8 utf8_turkish_ci NULL 1574def information_schema utf8 utf8_general_ci NULL 1575def mtr latin1 latin1_swedish_ci NULL 1576def mysql latin1 latin1_swedish_ci NULL 1577def performance_schema utf8 utf8_general_ci NULL 1578def test latin1 latin1_swedish_ci NULL 1579DROP DATABASE d10; 1580CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1581SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1582CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1583def d10 utf8 utf8_general_ci NULL 1584def information_schema utf8 utf8_general_ci NULL 1585def mtr latin1 latin1_swedish_ci NULL 1586def mysql latin1 latin1_swedish_ci NULL 1587def performance_schema utf8 utf8_general_ci NULL 1588def test latin1 latin1_swedish_ci NULL 1589ALTER SCHEMA d10 COLLATE utf8_czech_ci; 1590SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1591CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1592def d10 utf8 utf8_czech_ci NULL 1593def information_schema utf8 utf8_general_ci NULL 1594def mtr latin1 latin1_swedish_ci NULL 1595def mysql latin1 latin1_swedish_ci NULL 1596def performance_schema utf8 utf8_general_ci NULL 1597def test latin1 latin1_swedish_ci NULL 1598DROP DATABASE d10; 1599CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1600SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1601CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1602def d10 utf8 utf8_general_ci NULL 1603def information_schema utf8 utf8_general_ci NULL 1604def mtr latin1 latin1_swedish_ci NULL 1605def mysql latin1 latin1_swedish_ci NULL 1606def performance_schema utf8 utf8_general_ci NULL 1607def test latin1 latin1_swedish_ci NULL 1608ALTER SCHEMA d10 DEFAULT COLLATE utf8_czech_ci; 1609SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1610CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1611def d10 utf8 utf8_czech_ci NULL 1612def information_schema utf8 utf8_general_ci NULL 1613def mtr latin1 latin1_swedish_ci NULL 1614def mysql latin1 latin1_swedish_ci NULL 1615def performance_schema utf8 utf8_general_ci NULL 1616def test latin1 latin1_swedish_ci NULL 1617DROP DATABASE d10; 1618CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1619SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1620CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1621def d10 utf8 utf8_general_ci NULL 1622def information_schema utf8 utf8_general_ci NULL 1623def mtr latin1 latin1_swedish_ci NULL 1624def mysql latin1 latin1_swedish_ci NULL 1625def performance_schema utf8 utf8_general_ci NULL 1626def test latin1 latin1_swedish_ci NULL 1627ALTER SCHEMA d10 COLLATE utf8_danish_ci; 1628SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1629CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1630def d10 utf8 utf8_danish_ci NULL 1631def information_schema utf8 utf8_general_ci NULL 1632def mtr latin1 latin1_swedish_ci NULL 1633def mysql latin1 latin1_swedish_ci NULL 1634def performance_schema utf8 utf8_general_ci NULL 1635def test latin1 latin1_swedish_ci NULL 1636DROP DATABASE d10; 1637CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1638SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1639CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1640def d10 utf8 utf8_general_ci NULL 1641def information_schema utf8 utf8_general_ci NULL 1642def mtr latin1 latin1_swedish_ci NULL 1643def mysql latin1 latin1_swedish_ci NULL 1644def performance_schema utf8 utf8_general_ci NULL 1645def test latin1 latin1_swedish_ci NULL 1646ALTER SCHEMA d10 DEFAULT COLLATE utf8_danish_ci; 1647SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1648CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1649def d10 utf8 utf8_danish_ci NULL 1650def information_schema utf8 utf8_general_ci NULL 1651def mtr latin1 latin1_swedish_ci NULL 1652def mysql latin1 latin1_swedish_ci NULL 1653def performance_schema utf8 utf8_general_ci NULL 1654def test latin1 latin1_swedish_ci NULL 1655DROP DATABASE d10; 1656CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1657SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1658CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1659def d10 utf8 utf8_general_ci NULL 1660def information_schema utf8 utf8_general_ci NULL 1661def mtr latin1 latin1_swedish_ci NULL 1662def mysql latin1 latin1_swedish_ci NULL 1663def performance_schema utf8 utf8_general_ci NULL 1664def test latin1 latin1_swedish_ci NULL 1665ALTER SCHEMA d10 COLLATE utf8_lithuanian_ci; 1666SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1667CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1668def d10 utf8 utf8_lithuanian_ci NULL 1669def information_schema utf8 utf8_general_ci NULL 1670def mtr latin1 latin1_swedish_ci NULL 1671def mysql latin1 latin1_swedish_ci NULL 1672def performance_schema utf8 utf8_general_ci NULL 1673def test latin1 latin1_swedish_ci NULL 1674DROP DATABASE d10; 1675CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1676SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1677CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1678def d10 utf8 utf8_general_ci NULL 1679def information_schema utf8 utf8_general_ci NULL 1680def mtr latin1 latin1_swedish_ci NULL 1681def mysql latin1 latin1_swedish_ci NULL 1682def performance_schema utf8 utf8_general_ci NULL 1683def test latin1 latin1_swedish_ci NULL 1684ALTER SCHEMA d10 DEFAULT COLLATE utf8_lithuanian_ci; 1685SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1686CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1687def d10 utf8 utf8_lithuanian_ci NULL 1688def information_schema utf8 utf8_general_ci NULL 1689def mtr latin1 latin1_swedish_ci NULL 1690def mysql latin1 latin1_swedish_ci NULL 1691def performance_schema utf8 utf8_general_ci NULL 1692def test latin1 latin1_swedish_ci NULL 1693DROP DATABASE d10; 1694CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1695SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1696CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1697def d10 utf8 utf8_general_ci NULL 1698def information_schema utf8 utf8_general_ci NULL 1699def mtr latin1 latin1_swedish_ci NULL 1700def mysql latin1 latin1_swedish_ci NULL 1701def performance_schema utf8 utf8_general_ci NULL 1702def test latin1 latin1_swedish_ci NULL 1703ALTER SCHEMA d10 COLLATE utf8_slovak_ci; 1704SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1705CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1706def d10 utf8 utf8_slovak_ci NULL 1707def information_schema utf8 utf8_general_ci NULL 1708def mtr latin1 latin1_swedish_ci NULL 1709def mysql latin1 latin1_swedish_ci NULL 1710def performance_schema utf8 utf8_general_ci NULL 1711def test latin1 latin1_swedish_ci NULL 1712DROP DATABASE d10; 1713CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1714SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1715CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1716def d10 utf8 utf8_general_ci NULL 1717def information_schema utf8 utf8_general_ci NULL 1718def mtr latin1 latin1_swedish_ci NULL 1719def mysql latin1 latin1_swedish_ci NULL 1720def performance_schema utf8 utf8_general_ci NULL 1721def test latin1 latin1_swedish_ci NULL 1722ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovak_ci; 1723SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1724CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1725def d10 utf8 utf8_slovak_ci NULL 1726def information_schema utf8 utf8_general_ci NULL 1727def mtr latin1 latin1_swedish_ci NULL 1728def mysql latin1 latin1_swedish_ci NULL 1729def performance_schema utf8 utf8_general_ci NULL 1730def test latin1 latin1_swedish_ci NULL 1731DROP DATABASE d10; 1732CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1733SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1734CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1735def d10 utf8 utf8_general_ci NULL 1736def information_schema utf8 utf8_general_ci NULL 1737def mtr latin1 latin1_swedish_ci NULL 1738def mysql latin1 latin1_swedish_ci NULL 1739def performance_schema utf8 utf8_general_ci NULL 1740def test latin1 latin1_swedish_ci NULL 1741ALTER SCHEMA d10 COLLATE utf8_spanish2_ci; 1742SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1743CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1744def d10 utf8 utf8_spanish2_ci NULL 1745def information_schema utf8 utf8_general_ci NULL 1746def mtr latin1 latin1_swedish_ci NULL 1747def mysql latin1 latin1_swedish_ci NULL 1748def performance_schema utf8 utf8_general_ci NULL 1749def test latin1 latin1_swedish_ci NULL 1750DROP DATABASE d10; 1751CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1752SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1753CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1754def d10 utf8 utf8_general_ci NULL 1755def information_schema utf8 utf8_general_ci NULL 1756def mtr latin1 latin1_swedish_ci NULL 1757def mysql latin1 latin1_swedish_ci NULL 1758def performance_schema utf8 utf8_general_ci NULL 1759def test latin1 latin1_swedish_ci NULL 1760ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish2_ci; 1761SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1762CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1763def d10 utf8 utf8_spanish2_ci NULL 1764def information_schema utf8 utf8_general_ci NULL 1765def mtr latin1 latin1_swedish_ci NULL 1766def mysql latin1 latin1_swedish_ci NULL 1767def performance_schema utf8 utf8_general_ci NULL 1768def test latin1 latin1_swedish_ci NULL 1769DROP DATABASE d10; 1770CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1771SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1772CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1773def d10 utf8 utf8_general_ci NULL 1774def information_schema utf8 utf8_general_ci NULL 1775def mtr latin1 latin1_swedish_ci NULL 1776def mysql latin1 latin1_swedish_ci NULL 1777def performance_schema utf8 utf8_general_ci NULL 1778def test latin1 latin1_swedish_ci NULL 1779ALTER SCHEMA d10 COLLATE utf8_roman_ci; 1780SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1781CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1782def d10 utf8 utf8_roman_ci NULL 1783def information_schema utf8 utf8_general_ci NULL 1784def mtr latin1 latin1_swedish_ci NULL 1785def mysql latin1 latin1_swedish_ci NULL 1786def performance_schema utf8 utf8_general_ci NULL 1787def test latin1 latin1_swedish_ci NULL 1788DROP DATABASE d10; 1789CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1790SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1791CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1792def d10 utf8 utf8_general_ci NULL 1793def information_schema utf8 utf8_general_ci NULL 1794def mtr latin1 latin1_swedish_ci NULL 1795def mysql latin1 latin1_swedish_ci NULL 1796def performance_schema utf8 utf8_general_ci NULL 1797def test latin1 latin1_swedish_ci NULL 1798ALTER SCHEMA d10 DEFAULT COLLATE utf8_roman_ci; 1799SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1800CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1801def d10 utf8 utf8_roman_ci NULL 1802def information_schema utf8 utf8_general_ci NULL 1803def mtr latin1 latin1_swedish_ci NULL 1804def mysql latin1 latin1_swedish_ci NULL 1805def performance_schema utf8 utf8_general_ci NULL 1806def test latin1 latin1_swedish_ci NULL 1807DROP DATABASE d10; 1808CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1809SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1810CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1811def d10 utf8 utf8_general_ci NULL 1812def information_schema utf8 utf8_general_ci NULL 1813def mtr latin1 latin1_swedish_ci NULL 1814def mysql latin1 latin1_swedish_ci NULL 1815def performance_schema utf8 utf8_general_ci NULL 1816def test latin1 latin1_swedish_ci NULL 1817ALTER SCHEMA d10 COLLATE utf8_persian_ci; 1818SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1819CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1820def d10 utf8 utf8_persian_ci NULL 1821def information_schema utf8 utf8_general_ci NULL 1822def mtr latin1 latin1_swedish_ci NULL 1823def mysql latin1 latin1_swedish_ci NULL 1824def performance_schema utf8 utf8_general_ci NULL 1825def test latin1 latin1_swedish_ci NULL 1826DROP DATABASE d10; 1827CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1828SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1829CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1830def d10 utf8 utf8_general_ci NULL 1831def information_schema utf8 utf8_general_ci NULL 1832def mtr latin1 latin1_swedish_ci NULL 1833def mysql latin1 latin1_swedish_ci NULL 1834def performance_schema utf8 utf8_general_ci NULL 1835def test latin1 latin1_swedish_ci NULL 1836ALTER SCHEMA d10 DEFAULT COLLATE utf8_persian_ci; 1837SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1838CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1839def d10 utf8 utf8_persian_ci NULL 1840def information_schema utf8 utf8_general_ci NULL 1841def mtr latin1 latin1_swedish_ci NULL 1842def mysql latin1 latin1_swedish_ci NULL 1843def performance_schema utf8 utf8_general_ci NULL 1844def test latin1 latin1_swedish_ci NULL 1845DROP DATABASE d10; 1846CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1847SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1848CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1849def d10 utf8 utf8_general_ci NULL 1850def information_schema utf8 utf8_general_ci NULL 1851def mtr latin1 latin1_swedish_ci NULL 1852def mysql latin1 latin1_swedish_ci NULL 1853def performance_schema utf8 utf8_general_ci NULL 1854def test latin1 latin1_swedish_ci NULL 1855ALTER SCHEMA d10 COLLATE utf8_esperanto_ci; 1856SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1857CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1858def d10 utf8 utf8_esperanto_ci NULL 1859def information_schema utf8 utf8_general_ci NULL 1860def mtr latin1 latin1_swedish_ci NULL 1861def mysql latin1 latin1_swedish_ci NULL 1862def performance_schema utf8 utf8_general_ci NULL 1863def test latin1 latin1_swedish_ci NULL 1864DROP DATABASE d10; 1865CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1866SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1867CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1868def d10 utf8 utf8_general_ci NULL 1869def information_schema utf8 utf8_general_ci NULL 1870def mtr latin1 latin1_swedish_ci NULL 1871def mysql latin1 latin1_swedish_ci NULL 1872def performance_schema utf8 utf8_general_ci NULL 1873def test latin1 latin1_swedish_ci NULL 1874ALTER SCHEMA d10 DEFAULT COLLATE utf8_esperanto_ci; 1875SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1876CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1877def d10 utf8 utf8_esperanto_ci NULL 1878def information_schema utf8 utf8_general_ci NULL 1879def mtr latin1 latin1_swedish_ci NULL 1880def mysql latin1 latin1_swedish_ci NULL 1881def performance_schema utf8 utf8_general_ci NULL 1882def test latin1 latin1_swedish_ci NULL 1883DROP DATABASE d10; 1884CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1885SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1886CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1887def d10 utf8 utf8_general_ci NULL 1888def information_schema utf8 utf8_general_ci NULL 1889def mtr latin1 latin1_swedish_ci NULL 1890def mysql latin1 latin1_swedish_ci NULL 1891def performance_schema utf8 utf8_general_ci NULL 1892def test latin1 latin1_swedish_ci NULL 1893ALTER SCHEMA d10 COLLATE utf8_hungarian_ci; 1894SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1895CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1896def d10 utf8 utf8_hungarian_ci NULL 1897def information_schema utf8 utf8_general_ci NULL 1898def mtr latin1 latin1_swedish_ci NULL 1899def mysql latin1 latin1_swedish_ci NULL 1900def performance_schema utf8 utf8_general_ci NULL 1901def test latin1 latin1_swedish_ci NULL 1902DROP DATABASE d10; 1903CREATE DATABASE d10 DEFAULT CHARACTER SET utf8; 1904SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1905CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1906def d10 utf8 utf8_general_ci NULL 1907def information_schema utf8 utf8_general_ci NULL 1908def mtr latin1 latin1_swedish_ci NULL 1909def mysql latin1 latin1_swedish_ci NULL 1910def performance_schema utf8 utf8_general_ci NULL 1911def test latin1 latin1_swedish_ci NULL 1912ALTER SCHEMA d10 DEFAULT COLLATE utf8_hungarian_ci; 1913SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 1914CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 1915def d10 utf8 utf8_hungarian_ci NULL 1916def information_schema utf8 utf8_general_ci NULL 1917def mtr latin1 latin1_swedish_ci NULL 1918def mysql latin1 latin1_swedish_ci NULL 1919def performance_schema utf8 utf8_general_ci NULL 1920def test latin1 latin1_swedish_ci NULL 1921DROP DATABASE d10; 1922