1DROP DATABASE IF EXISTS d8; 2SHOW CHARACTER SET; 3Charset Description Default collation Maxlen 4big5 Big5 Traditional Chinese big5_chinese_ci 2 5dec8 DEC West European dec8_swedish_ci 1 6cp850 DOS West European cp850_general_ci 1 7hp8 HP West European hp8_english_ci 1 8koi8r KOI8-R Relcom Russian koi8r_general_ci 1 9latin1 cp1252 West European latin1_swedish_ci 1 10latin2 ISO 8859-2 Central European latin2_general_ci 1 11swe7 7bit Swedish swe7_swedish_ci 1 12ascii US ASCII ascii_general_ci 1 13ujis EUC-JP Japanese ujis_japanese_ci 3 14sjis Shift-JIS Japanese sjis_japanese_ci 2 15hebrew ISO 8859-8 Hebrew hebrew_general_ci 1 16tis620 TIS620 Thai tis620_thai_ci 1 17euckr EUC-KR Korean euckr_korean_ci 2 18koi8u KOI8-U Ukrainian koi8u_general_ci 1 19gb2312 GB2312 Simplified Chinese gb2312_chinese_ci 2 20greek ISO 8859-7 Greek greek_general_ci 1 21cp1250 Windows Central European cp1250_general_ci 1 22gbk GBK Simplified Chinese gbk_chinese_ci 2 23latin5 ISO 8859-9 Turkish latin5_turkish_ci 1 24armscii8 ARMSCII-8 Armenian armscii8_general_ci 1 25utf8 UTF-8 Unicode utf8_general_ci 3 26ucs2 UCS-2 Unicode ucs2_general_ci 2 27cp866 DOS Russian cp866_general_ci 1 28keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1 29macce Mac Central European macce_general_ci 1 30macroman Mac West European macroman_general_ci 1 31cp852 DOS Central European cp852_general_ci 1 32latin7 ISO 8859-13 Baltic latin7_general_ci 1 33utf8mb4 UTF-8 Unicode utf8mb4_general_ci 4 34cp1251 Windows Cyrillic cp1251_general_ci 1 35utf16 UTF-16 Unicode utf16_general_ci 4 36utf16le UTF-16LE Unicode utf16le_general_ci 4 37cp1256 Windows Arabic cp1256_general_ci 1 38cp1257 Windows Baltic cp1257_general_ci 1 39utf32 UTF-32 Unicode utf32_general_ci 4 40binary Binary pseudo charset binary 1 41geostd8 GEOSTD8 Georgian geostd8_general_ci 1 42cp932 SJIS for Windows Japanese cp932_japanese_ci 2 43eucjpms UJIS for Windows Japanese eucjpms_japanese_ci 3 44CREATE DATABASE d8; 45SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 46CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 47def d8 latin1 latin1_swedish_ci NULL 48def information_schema utf8 utf8_general_ci NULL 49def mtr latin1 latin1_swedish_ci NULL 50def mysql latin1 latin1_swedish_ci NULL 51def performance_schema utf8 utf8_general_ci NULL 52def test latin1 latin1_swedish_ci NULL 53ALTER DATABASE d8 CHARACTER SET ascii; 54SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 55CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 56def d8 ascii ascii_general_ci NULL 57def information_schema utf8 utf8_general_ci NULL 58def mtr latin1 latin1_swedish_ci NULL 59def mysql latin1 latin1_swedish_ci NULL 60def performance_schema utf8 utf8_general_ci NULL 61def test latin1 latin1_swedish_ci NULL 62DROP DATABASE d8; 63CREATE DATABASE d8; 64SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 65CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 66def d8 latin1 latin1_swedish_ci NULL 67def information_schema utf8 utf8_general_ci NULL 68def mtr latin1 latin1_swedish_ci NULL 69def mysql latin1 latin1_swedish_ci NULL 70def performance_schema utf8 utf8_general_ci NULL 71def test latin1 latin1_swedish_ci NULL 72ALTER DATABASE d8 CHARACTER SET utf8; 73SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 74CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 75def d8 utf8 utf8_general_ci NULL 76def information_schema utf8 utf8_general_ci NULL 77def mtr latin1 latin1_swedish_ci NULL 78def mysql latin1 latin1_swedish_ci NULL 79def performance_schema utf8 utf8_general_ci NULL 80def test latin1 latin1_swedish_ci NULL 81DROP DATABASE d8; 82CREATE DATABASE d8; 83SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 84CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 85def d8 latin1 latin1_swedish_ci NULL 86def information_schema utf8 utf8_general_ci NULL 87def mtr latin1 latin1_swedish_ci NULL 88def mysql latin1 latin1_swedish_ci NULL 89def performance_schema utf8 utf8_general_ci NULL 90def test latin1 latin1_swedish_ci NULL 91ALTER DATABASE d8 CHARACTER SET binary; 92SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 93CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 94def d8 binary binary NULL 95def information_schema utf8 utf8_general_ci NULL 96def mtr latin1 latin1_swedish_ci NULL 97def mysql latin1 latin1_swedish_ci NULL 98def performance_schema utf8 utf8_general_ci NULL 99def test latin1 latin1_swedish_ci NULL 100DROP DATABASE d8; 101CREATE DATABASE d8; 102SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 103CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 104def d8 latin1 latin1_swedish_ci NULL 105def information_schema utf8 utf8_general_ci NULL 106def mtr latin1 latin1_swedish_ci NULL 107def mysql latin1 latin1_swedish_ci NULL 108def performance_schema utf8 utf8_general_ci NULL 109def test latin1 latin1_swedish_ci NULL 110ALTER DATABASE d8 CHARACTER SET swe7; 111SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 112CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 113def d8 swe7 swe7_swedish_ci NULL 114def information_schema utf8 utf8_general_ci NULL 115def mtr latin1 latin1_swedish_ci NULL 116def mysql latin1 latin1_swedish_ci NULL 117def performance_schema utf8 utf8_general_ci NULL 118def test latin1 latin1_swedish_ci NULL 119DROP DATABASE d8; 120CREATE DATABASE d8; 121SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 122CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 123def d8 latin1 latin1_swedish_ci NULL 124def information_schema utf8 utf8_general_ci NULL 125def mtr latin1 latin1_swedish_ci NULL 126def mysql latin1 latin1_swedish_ci NULL 127def performance_schema utf8 utf8_general_ci NULL 128def test latin1 latin1_swedish_ci NULL 129ALTER DATABASE d8 CHARACTER SET cp1251; 130SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 131CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 132def d8 cp1251 cp1251_general_ci NULL 133def information_schema utf8 utf8_general_ci NULL 134def mtr latin1 latin1_swedish_ci NULL 135def mysql latin1 latin1_swedish_ci NULL 136def performance_schema utf8 utf8_general_ci NULL 137def test latin1 latin1_swedish_ci NULL 138DROP DATABASE d8; 139CREATE DATABASE d8; 140SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 141CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 142def d8 latin1 latin1_swedish_ci NULL 143def information_schema utf8 utf8_general_ci NULL 144def mtr latin1 latin1_swedish_ci NULL 145def mysql latin1 latin1_swedish_ci NULL 146def performance_schema utf8 utf8_general_ci NULL 147def test latin1 latin1_swedish_ci NULL 148ALTER DATABASE d8 DEFAULT CHARACTER SET ascii; 149SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 150CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 151def d8 ascii ascii_general_ci NULL 152def information_schema utf8 utf8_general_ci NULL 153def mtr latin1 latin1_swedish_ci NULL 154def mysql latin1 latin1_swedish_ci NULL 155def performance_schema utf8 utf8_general_ci NULL 156def test latin1 latin1_swedish_ci NULL 157DROP DATABASE d8; 158CREATE DATABASE d8; 159SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 160CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 161def d8 latin1 latin1_swedish_ci NULL 162def information_schema utf8 utf8_general_ci NULL 163def mtr latin1 latin1_swedish_ci NULL 164def mysql latin1 latin1_swedish_ci NULL 165def performance_schema utf8 utf8_general_ci NULL 166def test latin1 latin1_swedish_ci NULL 167ALTER DATABASE d8 DEFAULT CHARACTER SET utf8; 168SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 169CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 170def d8 utf8 utf8_general_ci NULL 171def information_schema utf8 utf8_general_ci NULL 172def mtr latin1 latin1_swedish_ci NULL 173def mysql latin1 latin1_swedish_ci NULL 174def performance_schema utf8 utf8_general_ci NULL 175def test latin1 latin1_swedish_ci NULL 176DROP DATABASE d8; 177CREATE DATABASE d8; 178SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 179CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 180def d8 latin1 latin1_swedish_ci NULL 181def information_schema utf8 utf8_general_ci NULL 182def mtr latin1 latin1_swedish_ci NULL 183def mysql latin1 latin1_swedish_ci NULL 184def performance_schema utf8 utf8_general_ci NULL 185def test latin1 latin1_swedish_ci NULL 186ALTER DATABASE d8 DEFAULT CHARACTER SET binary; 187SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 188CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 189def d8 binary binary NULL 190def information_schema utf8 utf8_general_ci NULL 191def mtr latin1 latin1_swedish_ci NULL 192def mysql latin1 latin1_swedish_ci NULL 193def performance_schema utf8 utf8_general_ci NULL 194def test latin1 latin1_swedish_ci NULL 195DROP DATABASE d8; 196CREATE DATABASE d8; 197SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 198CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 199def d8 latin1 latin1_swedish_ci NULL 200def information_schema utf8 utf8_general_ci NULL 201def mtr latin1 latin1_swedish_ci NULL 202def mysql latin1 latin1_swedish_ci NULL 203def performance_schema utf8 utf8_general_ci NULL 204def test latin1 latin1_swedish_ci NULL 205ALTER DATABASE d8 DEFAULT CHARACTER SET swe7; 206SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 207CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 208def d8 swe7 swe7_swedish_ci NULL 209def information_schema utf8 utf8_general_ci NULL 210def mtr latin1 latin1_swedish_ci NULL 211def mysql latin1 latin1_swedish_ci NULL 212def performance_schema utf8 utf8_general_ci NULL 213def test latin1 latin1_swedish_ci NULL 214DROP DATABASE d8; 215CREATE DATABASE d8; 216SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 217CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 218def d8 latin1 latin1_swedish_ci NULL 219def information_schema utf8 utf8_general_ci NULL 220def mtr latin1 latin1_swedish_ci NULL 221def mysql latin1 latin1_swedish_ci NULL 222def performance_schema utf8 utf8_general_ci NULL 223def test latin1 latin1_swedish_ci NULL 224ALTER DATABASE d8 DEFAULT CHARACTER SET cp1251; 225SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 226CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 227def d8 cp1251 cp1251_general_ci NULL 228def information_schema utf8 utf8_general_ci NULL 229def mtr latin1 latin1_swedish_ci NULL 230def mysql latin1 latin1_swedish_ci NULL 231def performance_schema utf8 utf8_general_ci NULL 232def test latin1 latin1_swedish_ci NULL 233DROP DATABASE d8; 234CREATE DATABASE d8; 235SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 236CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 237def d8 latin1 latin1_swedish_ci NULL 238def information_schema utf8 utf8_general_ci NULL 239def mtr latin1 latin1_swedish_ci NULL 240def mysql latin1 latin1_swedish_ci NULL 241def performance_schema utf8 utf8_general_ci NULL 242def test latin1 latin1_swedish_ci NULL 243ALTER SCHEMA d8 CHARACTER SET ascii; 244SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 245CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 246def d8 ascii ascii_general_ci NULL 247def information_schema utf8 utf8_general_ci NULL 248def mtr latin1 latin1_swedish_ci NULL 249def mysql latin1 latin1_swedish_ci NULL 250def performance_schema utf8 utf8_general_ci NULL 251def test latin1 latin1_swedish_ci NULL 252DROP DATABASE d8; 253CREATE DATABASE d8; 254SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 255CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 256def d8 latin1 latin1_swedish_ci NULL 257def information_schema utf8 utf8_general_ci NULL 258def mtr latin1 latin1_swedish_ci NULL 259def mysql latin1 latin1_swedish_ci NULL 260def performance_schema utf8 utf8_general_ci NULL 261def test latin1 latin1_swedish_ci NULL 262ALTER SCHEMA d8 CHARACTER SET utf8; 263SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 264CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 265def d8 utf8 utf8_general_ci NULL 266def information_schema utf8 utf8_general_ci NULL 267def mtr latin1 latin1_swedish_ci NULL 268def mysql latin1 latin1_swedish_ci NULL 269def performance_schema utf8 utf8_general_ci NULL 270def test latin1 latin1_swedish_ci NULL 271DROP DATABASE d8; 272CREATE DATABASE d8; 273SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 274CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 275def d8 latin1 latin1_swedish_ci NULL 276def information_schema utf8 utf8_general_ci NULL 277def mtr latin1 latin1_swedish_ci NULL 278def mysql latin1 latin1_swedish_ci NULL 279def performance_schema utf8 utf8_general_ci NULL 280def test latin1 latin1_swedish_ci NULL 281ALTER SCHEMA d8 CHARACTER SET binary; 282SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 283CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 284def d8 binary binary NULL 285def information_schema utf8 utf8_general_ci NULL 286def mtr latin1 latin1_swedish_ci NULL 287def mysql latin1 latin1_swedish_ci NULL 288def performance_schema utf8 utf8_general_ci NULL 289def test latin1 latin1_swedish_ci NULL 290DROP DATABASE d8; 291CREATE DATABASE d8; 292SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 293CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 294def d8 latin1 latin1_swedish_ci NULL 295def information_schema utf8 utf8_general_ci NULL 296def mtr latin1 latin1_swedish_ci NULL 297def mysql latin1 latin1_swedish_ci NULL 298def performance_schema utf8 utf8_general_ci NULL 299def test latin1 latin1_swedish_ci NULL 300ALTER SCHEMA d8 CHARACTER SET swe7; 301SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 302CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 303def d8 swe7 swe7_swedish_ci NULL 304def information_schema utf8 utf8_general_ci NULL 305def mtr latin1 latin1_swedish_ci NULL 306def mysql latin1 latin1_swedish_ci NULL 307def performance_schema utf8 utf8_general_ci NULL 308def test latin1 latin1_swedish_ci NULL 309DROP DATABASE d8; 310CREATE DATABASE d8; 311SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 312CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 313def d8 latin1 latin1_swedish_ci NULL 314def information_schema utf8 utf8_general_ci NULL 315def mtr latin1 latin1_swedish_ci NULL 316def mysql latin1 latin1_swedish_ci NULL 317def performance_schema utf8 utf8_general_ci NULL 318def test latin1 latin1_swedish_ci NULL 319ALTER SCHEMA d8 CHARACTER SET cp1251; 320SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 321CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 322def d8 cp1251 cp1251_general_ci NULL 323def information_schema utf8 utf8_general_ci NULL 324def mtr latin1 latin1_swedish_ci NULL 325def mysql latin1 latin1_swedish_ci NULL 326def performance_schema utf8 utf8_general_ci NULL 327def test latin1 latin1_swedish_ci NULL 328DROP DATABASE d8; 329CREATE DATABASE d8; 330SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 331CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 332def d8 latin1 latin1_swedish_ci NULL 333def information_schema utf8 utf8_general_ci NULL 334def mtr latin1 latin1_swedish_ci NULL 335def mysql latin1 latin1_swedish_ci NULL 336def performance_schema utf8 utf8_general_ci NULL 337def test latin1 latin1_swedish_ci NULL 338ALTER SCHEMA d8 DEFAULT CHARACTER SET ascii; 339SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 340CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 341def d8 ascii ascii_general_ci NULL 342def information_schema utf8 utf8_general_ci NULL 343def mtr latin1 latin1_swedish_ci NULL 344def mysql latin1 latin1_swedish_ci NULL 345def performance_schema utf8 utf8_general_ci NULL 346def test latin1 latin1_swedish_ci NULL 347DROP DATABASE d8; 348CREATE DATABASE d8; 349SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 350CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 351def d8 latin1 latin1_swedish_ci NULL 352def information_schema utf8 utf8_general_ci NULL 353def mtr latin1 latin1_swedish_ci NULL 354def mysql latin1 latin1_swedish_ci NULL 355def performance_schema utf8 utf8_general_ci NULL 356def test latin1 latin1_swedish_ci NULL 357ALTER SCHEMA d8 DEFAULT CHARACTER SET utf8; 358SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 359CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 360def d8 utf8 utf8_general_ci NULL 361def information_schema utf8 utf8_general_ci NULL 362def mtr latin1 latin1_swedish_ci NULL 363def mysql latin1 latin1_swedish_ci NULL 364def performance_schema utf8 utf8_general_ci NULL 365def test latin1 latin1_swedish_ci NULL 366DROP DATABASE d8; 367CREATE DATABASE d8; 368SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 369CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 370def d8 latin1 latin1_swedish_ci NULL 371def information_schema utf8 utf8_general_ci NULL 372def mtr latin1 latin1_swedish_ci NULL 373def mysql latin1 latin1_swedish_ci NULL 374def performance_schema utf8 utf8_general_ci NULL 375def test latin1 latin1_swedish_ci NULL 376ALTER SCHEMA d8 DEFAULT CHARACTER SET binary; 377SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 378CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 379def d8 binary binary NULL 380def information_schema utf8 utf8_general_ci NULL 381def mtr latin1 latin1_swedish_ci NULL 382def mysql latin1 latin1_swedish_ci NULL 383def performance_schema utf8 utf8_general_ci NULL 384def test latin1 latin1_swedish_ci NULL 385DROP DATABASE d8; 386CREATE DATABASE d8; 387SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 388CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 389def d8 latin1 latin1_swedish_ci NULL 390def information_schema utf8 utf8_general_ci NULL 391def mtr latin1 latin1_swedish_ci NULL 392def mysql latin1 latin1_swedish_ci NULL 393def performance_schema utf8 utf8_general_ci NULL 394def test latin1 latin1_swedish_ci NULL 395ALTER SCHEMA d8 DEFAULT CHARACTER SET swe7; 396SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 397CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 398def d8 swe7 swe7_swedish_ci NULL 399def information_schema utf8 utf8_general_ci NULL 400def mtr latin1 latin1_swedish_ci NULL 401def mysql latin1 latin1_swedish_ci NULL 402def performance_schema utf8 utf8_general_ci NULL 403def test latin1 latin1_swedish_ci NULL 404DROP DATABASE d8; 405CREATE DATABASE d8; 406SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 407CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 408def d8 latin1 latin1_swedish_ci NULL 409def information_schema utf8 utf8_general_ci NULL 410def mtr latin1 latin1_swedish_ci NULL 411def mysql latin1 latin1_swedish_ci NULL 412def performance_schema utf8 utf8_general_ci NULL 413def test latin1 latin1_swedish_ci NULL 414ALTER SCHEMA d8 DEFAULT CHARACTER SET cp1251; 415SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 416CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 417def d8 cp1251 cp1251_general_ci NULL 418def information_schema utf8 utf8_general_ci NULL 419def mtr latin1 latin1_swedish_ci NULL 420def mysql latin1 latin1_swedish_ci NULL 421def performance_schema utf8 utf8_general_ci NULL 422def test latin1 latin1_swedish_ci NULL 423DROP DATABASE d8; 424