Debian Codegraph @

mysql-test/suite/sys_vars/t/character_set_connection_func.test

raw
1 ############## mysql-test\t\character_set_connection_func.test ###############
2 # #
3 # Variable Name: character_set_connection #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: utf8 (session), latin1 (global) #
8 # Range: NA #
9 # #
10 # #
11 # Creation Date: 2008-03-08 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable character_set_connection #
15 # that checks the behavior of this variable #
16 # #
17 # Reference: #
18 # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html #
19 # #
20 ###############################################################################
21
22 --echo '#--------------------FN_DYNVARS_011_01-------------------------#'
23 ##########################################################################
24 # Check if setting character_set_connection is changed in new connection #
25 ##########################################################################
26
27 #save
28 SET @global_character_set_connection = @@global.character_set_connection;
29 SET @session_character_set_connection = @@session.character_set_connection;
30 SET @session_character_set_client = @@session.character_set_client;
31 SET @session_character_set_results = @@session.character_set_results;
32
33
34 SET @@global.character_set_connection = utf8;
35 --echo 'connect (con1,localhost,root,,,,)'
36 connect (con1,localhost,root,,,,);
37 --echo 'connection con1'
38 connection con1;
39 SELECT @@global.character_set_connection;
40 SELECT @@session.character_set_connection;
41 disconnect con1;
42
43 --echo '#--------------------FN_DYNVARS_011_02-------------------------#'
44 ###############################################################
45 # Begin the functionality Testing of character_set_connection #
46 ###############################################################
47
48 --echo 'connection default'
49 connection default;
50
51 --disable_warnings
52 DROP TABLE IF EXISTS t1;
53 --enable_warnings
54 CREATE TABLE t1(b CHAR(40) CHARACTER SET utf8);
55 #==============================================================================
56 --echo '--verify that character_set_connection converts character_set_client--'
57 #==============================================================================
58
59 SET @@session.character_set_client = utf8;
60 SET @@session.character_set_results = utf8;
61
62 SET @@session.character_set_connection = latin1;
63 SELECT 'ЁЂЃЄ' AS utf_text;
64
65 SET @@session.character_set_connection = utf8;
66 SELECT 'ЁЂЃЄ' AS utf_text;
67 #==============================================================================
68 --echo '---now inserting utf8 string with different character_set_connection--'
69 #==============================================================================
70 SET @@session.character_set_connection = ascii;
71 INSERT INTO t1 VALUES('ЁЂЃЄ');
72 SELECT * FROM t1;
73 TRUNCATE TABLE t1;
74
75 #==============================================================================
76 --echo '--now client & results charset in latin1 & connection charset in ascii-'
77 #==============================================================================
78 SET @@session.character_set_connection = ascii;
79 SET @@session.character_set_client = latin1;
80 SET @@session.character_set_results = latin1;
81 INSERT INTO t1 VALUES('ЁЂЃЄ');
82 SELECT * FROM t1;
83 TRUNCATE TABLE t1;
84
85 #==============================================================================
86 # set names should set character sets [client,connection,results]
87 #==============================================================================
88 SET NAMES utf8;
89 INSERT INTO t1 VALUES('ЁЂЃЄ');
90 SELECT * FROM t1;
91 TRUNCATE TABLE t1;
92
93
94 # Cleanup
95 SET @@global.character_set_connection = @global_character_set_connection;
96 SET @@session.character_set_connection = @session_character_set_connection;
97 SET @@session.character_set_client = @session_character_set_client;
98 SET @@session.character_set_results = @session_character_set_results;
99
100 DROP TABLE t1;
101
102 #############################################################
103 # End of functionality Testing for character_set_connection #
104 #############################################################
105