1--disable_warnings 2DROP DATABASE IF EXISTS d11; 3--enable_warnings 4CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; 5SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 6ALTER DATABASE d11 CHARACTER SET utf8 COLLATE utf8_general_ci; 7SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 8DROP DATABASE d11; 9CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; 10SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 11ALTER DATABASE d11 CHARACTER SET latin2 COLLATE latin2_general_ci; 12SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 13DROP DATABASE d11; 14CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; 15SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 16ALTER DATABASE d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; 17SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 18DROP DATABASE d11; 19CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; 20SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 21ALTER SCHEMA d11 CHARACTER SET utf8 COLLATE utf8_general_ci; 22SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 23DROP DATABASE d11; 24CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; 25SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 26ALTER SCHEMA d11 CHARACTER SET latin2 COLLATE latin2_general_ci; 27SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 28DROP DATABASE d11; 29CREATE DATABASE d11 DEFAULT CHARACTER SET ascii DEFAULT COLLATE ascii_bin; 30SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 31ALTER SCHEMA d11 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; 32SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 33DROP DATABASE d11; 34 35