Edit File: db_create_character_set_collate.test
--disable_warnings DROP DATABASE IF EXISTS d13; --enable_warnings CREATE DATABASE d13 CHARACTER SET utf8 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; DROP DATABASE d13; CREATE DATABASE d13 CHARACTER SET latin2 COLLATE latin2_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; DROP DATABASE d13; CREATE DATABASE d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; DROP DATABASE d13; CREATE SCHEMA d13 CHARACTER SET utf8 COLLATE utf8_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; DROP SCHEMA d13; CREATE SCHEMA d13 CHARACTER SET latin2 COLLATE latin2_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; DROP SCHEMA d13; CREATE SCHEMA d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; DROP SCHEMA d13;
Back to File Manager