1DROP DATABASE IF EXISTS d13; 2CREATE DATABASE d13 CHARACTER SET utf8 COLLATE utf8_general_ci; 3SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 4CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 5def d13 utf8 utf8_general_ci NULL 6def information_schema utf8 utf8_general_ci NULL 7def mtr latin1 latin1_swedish_ci NULL 8def mysql latin1 latin1_swedish_ci NULL 9def performance_schema utf8 utf8_general_ci NULL 10def test latin1 latin1_swedish_ci NULL 11DROP DATABASE d13; 12CREATE DATABASE d13 CHARACTER SET latin2 COLLATE latin2_general_ci; 13SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 14CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 15def d13 latin2 latin2_general_ci NULL 16def information_schema utf8 utf8_general_ci NULL 17def mtr latin1 latin1_swedish_ci NULL 18def mysql latin1 latin1_swedish_ci NULL 19def performance_schema utf8 utf8_general_ci NULL 20def test latin1 latin1_swedish_ci NULL 21DROP DATABASE d13; 22CREATE DATABASE d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; 23SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 24CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 25def d13 cp1250 cp1250_croatian_ci NULL 26def information_schema utf8 utf8_general_ci NULL 27def mtr latin1 latin1_swedish_ci NULL 28def mysql latin1 latin1_swedish_ci NULL 29def performance_schema utf8 utf8_general_ci NULL 30def test latin1 latin1_swedish_ci NULL 31DROP DATABASE d13; 32CREATE SCHEMA d13 CHARACTER SET utf8 COLLATE utf8_general_ci; 33SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 34CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 35def d13 utf8 utf8_general_ci NULL 36def information_schema utf8 utf8_general_ci NULL 37def mtr latin1 latin1_swedish_ci NULL 38def mysql latin1 latin1_swedish_ci NULL 39def performance_schema utf8 utf8_general_ci NULL 40def test latin1 latin1_swedish_ci NULL 41DROP SCHEMA d13; 42CREATE SCHEMA d13 CHARACTER SET latin2 COLLATE latin2_general_ci; 43SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 44CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 45def d13 latin2 latin2_general_ci NULL 46def information_schema utf8 utf8_general_ci NULL 47def mtr latin1 latin1_swedish_ci NULL 48def mysql latin1 latin1_swedish_ci NULL 49def performance_schema utf8 utf8_general_ci NULL 50def test latin1 latin1_swedish_ci NULL 51DROP SCHEMA d13; 52CREATE SCHEMA d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; 53SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; 54CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH 55def d13 cp1250 cp1250_croatian_ci NULL 56def information_schema utf8 utf8_general_ci NULL 57def mtr latin1 latin1_swedish_ci NULL 58def mysql latin1 latin1_swedish_ci NULL 59def performance_schema utf8 utf8_general_ci NULL 60def test latin1 latin1_swedish_ci NULL 61DROP SCHEMA d13; 62