Debian Codegraph @

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

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