mirror of
https://github.com/MariaDB/server.git
synced 2025-02-10 23:45:34 +01: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.
41 lines
1.3 KiB
Text
41 lines
1.3 KiB
Text
DROP USER dbdict_test@localhost;
|
|
CREATE USER dbdict_test@localhost;
|
|
connect con,localhost,dbdict_test,,;
|
|
|
|
SELECT *
|
|
FROM information_schema.character_sets
|
|
WHERE character_set_name IN ('utf8mb3','latin1','binary')
|
|
ORDER BY character_set_name;
|
|
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
|
|
binary binary Binary pseudo charset 1
|
|
latin1 latin1_swedish_ci cp1252 West European 1
|
|
utf8mb3 utf8mb3_general_ci UTF-8 Unicode 3
|
|
|
|
SELECT *
|
|
FROM information_schema.collations
|
|
WHERE character_set_name IN ('utf8mb3','latin1','binary')
|
|
AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
|
|
OR
|
|
collation_name LIKE CONCAT(character_set_name,'_bin'))
|
|
ORDER BY collation_name;
|
|
COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
|
|
latin1_bin latin1 47 Yes 1
|
|
latin1_general_ci latin1 48 Yes 1
|
|
utf8mb3_bin utf8mb3 83 Yes 1
|
|
utf8mb3_general_ci utf8mb3 33 Yes Yes 1
|
|
|
|
SELECT *
|
|
FROM information_schema.collation_character_set_applicability
|
|
WHERE character_set_name IN ('utf8mb3','latin1','binary')
|
|
AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
|
|
OR
|
|
collation_name LIKE CONCAT(character_set_name,'_bin'))
|
|
ORDER BY collation_name, character_set_name;
|
|
COLLATION_NAME CHARACTER_SET_NAME
|
|
latin1_bin latin1
|
|
latin1_general_ci latin1
|
|
utf8mb3_bin utf8mb3
|
|
utf8mb3_general_ci utf8mb3
|
|
connection default;
|
|
disconnect con;
|
|
DROP USER dbdict_test@localhost;
|