database/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-07 00:04:31 +03:00
Code Activity
Files
MDEV-36810
mariadb/mysql-test/suite/engines/funcs/r/db_create_character_set.result
Alexander Barkov 36eba98817 MDEV-19123 Change default charset from latin1 to utf8mb4 
Changing the default server character set from latin1 to utf8mb4.
2024-07-11 10:21:07 +04:00

112 lines
5.4 KiB
Plaintext
Raw Permalink Blame History

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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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_uca1400_ai_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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_uca1400_ai_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_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 utf8mb4 utf8mb4_uca1400_ai_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
DROP SCHEMA d12;
View Git Blame Copy Permalink