mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +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.
58 lines
2.0 KiB
Plaintext
58 lines
2.0 KiB
Plaintext
'#--------------------FN_DYNVARS_011_01-------------------------#'
|
|
SET @global_character_set_connection = @@global.character_set_connection;
|
|
SET @session_character_set_connection = @@session.character_set_connection;
|
|
SET @session_character_set_client = @@session.character_set_client;
|
|
SET @session_character_set_results = @@session.character_set_results;
|
|
SET @@global.character_set_connection = utf8;
|
|
connect con1,localhost,root,,,,;
|
|
connection con1;
|
|
SELECT @@global.character_set_connection;
|
|
@@global.character_set_connection
|
|
utf8mb3
|
|
SELECT @@session.character_set_connection;
|
|
@@session.character_set_connection
|
|
latin1
|
|
disconnect con1;
|
|
'#--------------------FN_DYNVARS_011_02-------------------------#'
|
|
connection default;
|
|
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(b CHAR(40) CHARACTER SET utf8);
|
|
'--verify that character_set_connection converts character_set_client--'
|
|
SET @@session.character_set_client = utf8;
|
|
SET @@session.character_set_results = utf8;
|
|
SET @@session.character_set_connection = latin1;
|
|
SELECT 'ЁЂЃЄ' AS utf_text;
|
|
utf_text
|
|
????
|
|
SET @@session.character_set_connection = utf8;
|
|
SELECT 'ЁЂЃЄ' AS utf_text;
|
|
utf_text
|
|
ЁЂЃЄ
|
|
'---now inserting utf8 string with different character_set_connection--'
|
|
SET @@session.character_set_connection = ascii;
|
|
INSERT INTO t1 VALUES('ЁЂЃЄ');
|
|
SELECT * FROM t1;
|
|
b
|
|
????
|
|
TRUNCATE TABLE t1;
|
|
'--now client & results charset in latin1 & connection charset in ascii-'
|
|
SET @@session.character_set_connection = ascii;
|
|
SET @@session.character_set_client = latin1;
|
|
SET @@session.character_set_results = latin1;
|
|
INSERT INTO t1 VALUES('ЁЂЃЄ');
|
|
SELECT * FROM t1;
|
|
b
|
|
????????
|
|
TRUNCATE TABLE t1;
|
|
SET NAMES utf8;
|
|
INSERT INTO t1 VALUES('ЁЂЃЄ');
|
|
SELECT * FROM t1;
|
|
b
|
|
ЁЂЃЄ
|
|
TRUNCATE TABLE t1;
|
|
SET @@global.character_set_connection = @global_character_set_connection;
|
|
SET @@session.character_set_connection = @session_character_set_connection;
|
|
SET @@session.character_set_client = @session_character_set_client;
|
|
SET @@session.character_set_results = @session_character_set_results;
|
|
DROP TABLE t1;
|