1'#--------------------FN_DYNVARS_009_01-------------------------#'
2SET @global_character_set_server = @@global.character_set_server;
3SET @session_character_set_server = @@session.character_set_server;
4SET @@global.character_set_server = utf8;
5connect  con1,localhost,root,,,,;
6connection con1;
7SELECT @@global.character_set_server;
8@@global.character_set_server
9utf8
10SELECT @@session.character_set_server;
11@@session.character_set_server
12utf8
13disconnect con1;
14'#--------------------FN_DYNVARS_009_02-------------------------#'
15connection default;
16'--global character_set_server should not effects current connection--'
17select @@character_set_database=@@character_set_connection;
18@@character_set_database=@@character_set_connection
191
20SET @@global.character_set_server = utf8;
21CREATE DATABASE db1;
22USE db1;
23SHOW CREATE DATABASE db1;
24Database	Create Database
25db1	CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET latin1 */
26DROP DATABASE db1;
27select @@character_set_database;
28@@character_set_database
29latin1
30'---session character_set_server should effects current connection---'
31SET @@session.character_set_server = utf8;
32CREATE DATABASE db1;
33USE db1;
34SHOW CREATE DATABASE db1;
35Database	Create Database
36db1	CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8 */
37DROP DATABASE db1;
38select @@character_set_database;
39@@character_set_database
40utf8
41'----test with new connection----'
42connect  con1,localhost,root,,,,;
43connection con1;
44SELECT @@session.character_set_server;
45@@session.character_set_server
46utf8
47'----------character set not specified---------'
48CREATE DATABASE db1;
49USE db1;
50SHOW CREATE DATABASE db1;
51Database	Create Database
52db1	CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8 */
53DROP DATABASE db1;
54SELECT @@character_set_database;
55@@character_set_database
56utf8
57'----------ascii character set specified----------'
58CREATE DATABASE db1 character set ascii;
59USE db1;
60SHOW CREATE DATABASE db1;
61Database	Create Database
62db1	CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET ascii */
63DROP DATABASE db1;
64select @@character_set_database;
65@@character_set_database
66utf8
67disconnect con1;
68connection default;
69SET @@global.character_set_server = @global_character_set_server;
70SET @@session.character_set_server = @session_character_set_server;
71