Debian Codegraph @

mysql-test/suite/sys_vars/r/character_set_connection_func.result

raw
1 '#--------------------FN_DYNVARS_011_01-------------------------#'
2 SET @global_collation_connection = @@global.collation_connection;
3 SET @session_collation_connection = @@session.collation_connection;
4 SET @global_character_set_connection = @@global.character_set_connection;
5 SET @session_character_set_connection = @@session.character_set_connection;
6 SET @session_character_set_client = @@session.character_set_client;
7 SET @session_character_set_results = @@session.character_set_results;
8 SET @@global.character_set_connection = utf8;
9 connect con1,localhost,root,,,,;
10 connection con1;
11 SELECT @@global.character_set_connection;
12 @@global.character_set_connection
13 utf8mb3
14 SELECT @@session.character_set_connection;
15 @@session.character_set_connection
16 latin1
17 disconnect con1;
18 '#--------------------FN_DYNVARS_011_02-------------------------#'
19 connection default;
20 DROP TABLE IF EXISTS t1;
21 CREATE TABLE t1(b CHAR(40) CHARACTER SET utf8);
22 '--verify that character_set_connection converts character_set_client--'
23 SET @@session.character_set_client = utf8;
24 SET @@session.character_set_results = utf8;
25 SET @@session.character_set_connection = latin1;
26 SELECT 'ЁЂЃЄ' AS utf_text;
27 utf_text
28 ????
29 SET @@session.character_set_connection = utf8;
30 SELECT 'ЁЂЃЄ' AS utf_text;
31 utf_text
32 ЁЂЃЄ
33 '---now inserting utf8 string with different character_set_connection--'
34 SET @@session.character_set_connection = ascii;
35 INSERT INTO t1 VALUES('ЁЂЃЄ');
36 SELECT * FROM t1;
37 b
38 ????
39 TRUNCATE TABLE t1;
40 '--now client & results charset in latin1 & connection charset in ascii-'
41 SET @@session.character_set_connection = ascii;
42 SET @@session.character_set_client = latin1;
43 SET @@session.character_set_results = latin1;
44 INSERT INTO t1 VALUES('ЁЂЃЄ');
45 SELECT * FROM t1;
46 b
47 ????????
48 TRUNCATE TABLE t1;
49 SET NAMES utf8;
50 INSERT INTO t1 VALUES('ЁЂЃЄ');
51 SELECT * FROM t1;
52 b
53 ЁЂЃЄ
54 TRUNCATE TABLE t1;
55 SET @@global.collation_connection = @global_collation_connection;
56 SET @@session.collation_connection = @session_collation_connection;
57 SET @@session.character_set_client = @session_character_set_client;
58 SET @@session.character_set_results = @session_character_set_results;
59 DROP TABLE t1;