Debian Codegraph @

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

raw
1 '#--------------------FN_DYNVARS_009_01-------------------------#'
2 SET @global_character_set_server = @@global.character_set_server;
3 SET @session_character_set_server = @@session.character_set_server;
4 SET @@global.character_set_server = utf8;
5 Warnings:
6 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
7 'connect (con1,localhost,root,,,,)'
8 'connection con1'
9 SELECT @@global.character_set_server;
10 @@global.character_set_server
11 utf8mb3
12 SELECT @@session.character_set_server;
13 @@session.character_set_server
14 utf8mb3
15 '#--------------------FN_DYNVARS_009_02-------------------------#'
16 'connection default'
17 '---global character_set_server should not effects current connection---'
18 SET @@global.character_set_server = utf8;
19 Warnings:
20 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
21 CREATE DATABASE db1;
22 USE db1;
23 SHOW CREATE DATABASE db1;
24 Database Create Database
25 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
26 DROP DATABASE db1;
27 select @@character_set_database;
28 @@character_set_database
29 utf8mb4
30 '---session character_set_server should effects current connection---'
31 SET @@session.character_set_server = utf8;
32 Warnings:
33 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
34 CREATE DATABASE db1;
35 USE db1;
36 SHOW CREATE DATABASE db1;
37 Database Create Database
38 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */
39 DROP DATABASE db1;
40 select @@character_set_database;
41 @@character_set_database
42 utf8mb3
43 '----test with new connection----'
44 'connect (con1,localhost,root,,,,)'
45 'connection con1'
46 SELECT @@session.character_set_server;
47 @@session.character_set_server
48 utf8mb3
49 '----------character set not specified---------'
50 CREATE DATABASE db1;
51 USE db1;
52 SHOW CREATE DATABASE db1;
53 Database Create Database
54 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */
55 DROP DATABASE db1;
56 SELECT @@character_set_database;
57 @@character_set_database
58 utf8mb3
59 '----------ascii character set specified----------'
60 CREATE DATABASE db1 character set ascii;
61 USE db1;
62 SHOW CREATE DATABASE db1;
63 Database Create Database
64 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET ascii */ /*!80016 DEFAULT ENCRYPTION='N' */
65 DROP DATABASE db1;
66 select @@character_set_database;
67 @@character_set_database
68 utf8mb3
69 'connection default;'
70 SET @@global.character_set_server = @global_character_set_server;
71 SET @@session.character_set_server = @session_character_set_server;