1
############## mysql-test\t\character_set_results_func.test ##################
3
# Variable Name: character_set_results #
4
# Scope: GLOBAL | SESSION #
5
# Access Type: Dynamic #
7
# Default Value: utf8 (session), latin1 (global) #
11
# Creation Date: 2008-03-08 #
14
# Description: Test Cases of Dynamic System Variable character_set_results #
15
# that checks the behavior of this variable #
17
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18
# server-system-variables.html #
20
###############################################################################
22
--echo '#--------------------FN_DYNVARS_012_01-------------------------#'
23
#######################################################################
24
# Check if setting character_set_results is changed in new connection #
25
#######################################################################
28
SET @global_character_set_results = @@global.character_set_results;
29
SET @session_character_set_results = @@session.character_set_results;
32
SET @@global.character_set_results = utf8;
33
--echo 'connect (con1,localhost,root,,,,)'
34
connect (con1,localhost,root,,,,);
35
--echo 'connection con1'
37
SELECT @@global.character_set_results;
38
SELECT @@session.character_set_results;
42
--echo '#--------------------FN_DYNVARS_012_02-------------------------#'
43
#############################################################
44
# Begin the functionality Testing of character_set_results #
45
#############################################################
47
--echo 'connection default'
51
DROP TABLE IF EXISTS t1;
54
CREATE TABLE t1(b CHAR(40) character set utf8);
57
#==============================================================================
58
--echo '----check string literals against different character_set_results---'
59
#==============================================================================
60
--echo check if results are converted to character_set_results
61
SET @@session.character_set_results = greek;
62
SELECT 'ЁЂЃЄ' AS utf_text;
64
--echo check effect of character_set_results when introducers are used
65
SET @@session.character_set_results = latin1;
66
SELECT _latin1'M�ller' AS latin1_text;
67
SET @@session.character_set_results = ascii;
68
SELECT _latin1'M�ller' AS latin1_text;
70
--echo check when we dont want any conversion
71
SET @@session.character_set_results = NULL;
72
SELECT 'ЁЂЃЄ' AS utf_text;
74
#==============================================================================
75
--echo '---check results from table against different character_set_results--'
76
#==============================================================================
77
INSERT INTO t1 VALUES(_utf8'ЁЂЃЄ');
78
INSERT INTO t1 VALUES('ФХЦЧШ');
80
SET @@session.character_set_results = NULL;
81
SELECT b, CHAR_LENGTH(b) FROM t1;
83
SET @@session.character_set_results = utf8;
84
SELECT b, CHAR_LENGTH(b) FROM t1;
86
SET @@session.character_set_results = koi8r;
87
SELECT b, CHAR_LENGTH(b) FROM t1;
89
SET @@session.character_set_results = cp1250;
90
SELECT b, CHAR_LENGTH(b) FROM t1;
94
--echo 'connection default;'
96
SET @@global.character_set_results = @global_character_set_results;
97
SET @@session.character_set_results = @session_character_set_results;
99
##########################################################
100
# End of functionality Testing for character_set_results #
101
##########################################################