1
############## mysql-test\t\character_set_server_func.test ###################
3
# Variable Name: character_set_server #
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_server #
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
###############################################################################
21
--echo '#--------------------FN_DYNVARS_009_01-------------------------#'
22
######################################################################
23
# Check if setting character_set_server is changed in new connection #
24
######################################################################
27
SET @global_character_set_server = @@global.character_set_server;
28
SET @session_character_set_server = @@session.character_set_server;
31
SET @@global.character_set_server = utf8;
32
--echo 'connect (con1,localhost,root,,,,)'
33
connect (con1,localhost,root,,,,);
34
--echo 'connection con1'
36
SELECT @@global.character_set_server;
37
SELECT @@session.character_set_server;
40
--echo '#--------------------FN_DYNVARS_009_02-------------------------#'
41
#############################################################
42
# Begin the functionality Testing of character_set_server #
43
#############################################################
45
--echo 'connection default'
47
#The server character set and collation are used as default values if the database
48
#character set and collation are not specified in CREATE DATABASE statements.
50
#==============================================================================
51
--echo '---global character_set_server should not effects current connection---'
52
#==============================================================================
54
SET @@global.character_set_server = utf8;
57
SHOW CREATE DATABASE db1;
59
select @@character_set_database;
61
#==============================================================================
62
--echo '---session character_set_server should effects current connection---'
63
#==============================================================================
64
SET @@session.character_set_server = utf8;
67
SHOW CREATE DATABASE db1;
69
select @@character_set_database;
71
#==============================================================================
72
--echo '----test with new connection----'
73
#==============================================================================
75
--echo 'connect (con1,localhost,root,,,,)'
76
connect (con1,localhost,root,,,,);
77
--echo 'connection con1'
80
SELECT @@session.character_set_server;
82
--echo '----------character set not specified---------'
85
SHOW CREATE DATABASE db1;
87
SELECT @@character_set_database;
89
--echo '----------ascii character set specified----------'
90
CREATE DATABASE db1 character set ascii;
92
SHOW CREATE DATABASE db1;
94
select @@character_set_database;
99
--echo 'connection default;'
101
SET @@global.character_set_server = @global_character_set_server;
102
SET @@session.character_set_server = @session_character_set_server;
104
############################################################
105
# End of functionality Testing for character_set_server #
106
############################################################