DROP DATABASE IF EXISTS d12;
CREATE DATABASE d12 CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	ascii	ascii_general_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP DATABASE d12;
CREATE DATABASE d12 CHARACTER SET utf8;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	utf8mb3	utf8mb3_general_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP DATABASE d12;
CREATE DATABASE d12 CHARACTER SET binary;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	binary	binary	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP DATABASE d12;
CREATE DATABASE d12 CHARACTER SET swe7;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	swe7	swe7_swedish_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP DATABASE d12;
CREATE DATABASE d12 CHARACTER SET cp1251;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	cp1251	cp1251_general_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP DATABASE d12;
CREATE SCHEMA d12 CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	ascii	ascii_general_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP SCHEMA d12;
CREATE SCHEMA d12 CHARACTER SET utf8;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	utf8mb3	utf8mb3_general_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP SCHEMA d12;
CREATE SCHEMA d12 CHARACTER SET binary;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	binary	binary	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP SCHEMA d12;
CREATE SCHEMA d12 CHARACTER SET swe7;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	swe7	swe7_swedish_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP SCHEMA d12;
CREATE SCHEMA d12 CHARACTER SET cp1251;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	SCHEMA_COMMENT
def	d12	cp1251	cp1251_general_ci	NULL	
def	information_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	mtr	latin1	latin1_swedish_ci	NULL	
def	mysql	latin1	latin1_swedish_ci	NULL	
def	performance_schema	utf8mb3	utf8mb3_general_ci	NULL	
def	sys	utf8mb3	utf8mb3_general_ci	NULL	
def	test	latin1	latin1_swedish_ci	NULL	
DROP SCHEMA d12;