mirror of
https://github.com/MariaDB/server.git
synced 2025-09-11 05:52:26 +03:00
2fdb556e04
This patch changes the main name of 3 byte character set from utf8 to utf8mb3. New old_mode UTF8_IS_UTF8MB3 is added and set TRUE by default, so that utf8 would mean utf8mb3. If not set, utf8 would mean utf8mb4.
112 lines
5.2 KiB
Plaintext
112 lines
5.2 KiB
Plaintext
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;
|