release/src/router/mysql/mysql-test/suite/engines/funcs/r/db_alter_character_set.result

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