Debian Codegraph @

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

raw
1 '#--------------------FN_DYNVARS_008_01-------------------------#'
2 SET @global_character_set_database = @@global.character_set_database;
3 SET @session_character_set_database = @@session.character_set_database;
4 SET @session_character_set_server = @@session.character_set_server;
5 SET @global_character_set_server = @@global.character_set_server;
6 SET @@global.character_set_database = utf8;
7 Warnings:
8 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.
9 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
10 'connect (con1,localhost,root,,,,)'
11 'connection con1'
12 SELECT @@global.character_set_database;
13 @@global.character_set_database
14 utf8mb3
15 SELECT @@session.character_set_database;
16 @@session.character_set_database
17 utf8mb4
18 '#--------------------FN_DYNVARS_008_02-------------------------#'
19 'connection default'
20 DROP TABLE IF EXISTS t1;
21 '--check if setting session character_set_database effects new databases'
22 SET @@session.character_set_server = utf8;
23 Warnings:
24 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.
25 SELECT @@session.character_set_database;
26 @@session.character_set_database
27 utf8mb4
28 SET @@session.character_set_database = latin5;
29 Warnings:
30 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
31 SELECT @@session.character_set_database;
32 @@session.character_set_database
33 latin5
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 CREATE TABLE t1(a INT, b VARCHAR(40));
40 SHOW CREATE TABLE t1;
41 Table Create Table
42 t1 CREATE TABLE `t1` (
43 `a` int DEFAULT NULL,
44 `b` varchar(40) DEFAULT NULL
45 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
46 DROP TABLE t1;
47 DROP DATABASE db1;
48 '--ascii character set specified--'
49 CREATE DATABASE db1 CHARACTER SET ascii;
50 USE db1;
51 SHOW CREATE DATABASE db1;
52 Database Create Database
53 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET ascii */ /*!80016 DEFAULT ENCRYPTION='N' */
54 CREATE TABLE t1(a INT, b VARCHAR(40));
55 SHOW CREATE TABLE t1;
56 Table Create Table
57 t1 CREATE TABLE `t1` (
58 `a` int DEFAULT NULL,
59 `b` varchar(40) DEFAULT NULL
60 ) ENGINE=InnoDB DEFAULT CHARSET=ascii
61 DROP TABLE t1;
62 DROP DATABASE db1;
63 SET GLOBAL character_set_server=latin5;
64 CREATE DATABASE csdb CHARACTER SET = utf8;
65 Warnings:
66 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.
67 USE csdb;
68 DROP DATABASE csdb;
69 SELECT @@character_set_database;
70 @@character_set_database
71 latin5
72 SET @@global.character_set_database = @global_character_set_database;
73 Warnings:
74 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
75 SET @@session.character_set_database = @session_character_set_database;
76 Warnings:
77 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
78 SET @@session.character_set_server = @session_character_set_server;
79 SET @@global.character_set_server = @global_character_set_server;