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