Debian Codegraph @

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

raw
1 '#--------------------FN_DYNVARS_008_01-------------------------#'
2 SET @global_collation_database = @@global.collation_database;
3 SET @global_collation_server = @@global.collation_server;
4 SET @session_collation_database = @@session.collation_database;
5 SET @session_collation_server = @@session.collation_server;
6 SET @global_character_set_database = @@global.character_set_database;
7 SET @session_character_set_database = @@session.character_set_database;
8 SET @session_character_set_server = @@session.character_set_server;
9 SET @global_character_set_server = @@global.character_set_server;
10 SET @@global.character_set_database = utf8;
11 connect con1,localhost,root,,,,;
12 connection con1;
13 SELECT @@global.character_set_database;
14 @@global.character_set_database
15 utf8mb3
16 SELECT @@session.character_set_database;
17 @@session.character_set_database
18 utf8mb4
19 disconnect con1;
20 '#--------------------FN_DYNVARS_008_02-------------------------#'
21 connection default;
22 DROP TABLE IF EXISTS t1;
23 '--check if setting session character_set_database effects new databases'
24 SET @@session.character_set_server = utf8;
25 SELECT @@session.character_set_database;
26 @@session.character_set_database
27 utf8mb4
28 SET @@session.character_set_database = latin5;
29 SELECT @@session.character_set_database;
30 @@session.character_set_database
31 latin5
32 CREATE DATABASE db1;
33 USE db1;
34 SHOW CREATE DATABASE db1;
35 Database Create Database
36 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */
37 CREATE TABLE t1(a INT, b VARCHAR(40));
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `a` int(11) DEFAULT NULL,
42 `b` varchar(40) DEFAULT NULL
43 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
44 DROP TABLE t1;
45 DROP DATABASE db1;
46 '--ascii character set specified--'
47 CREATE DATABASE db1 CHARACTER SET ascii;
48 USE db1;
49 SHOW CREATE DATABASE db1;
50 Database Create Database
51 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET ascii COLLATE ascii_general_ci */
52 CREATE TABLE t1(a INT, b VARCHAR(40));
53 SHOW CREATE TABLE t1;
54 Table Create Table
55 t1 CREATE TABLE `t1` (
56 `a` int(11) DEFAULT NULL,
57 `b` varchar(40) DEFAULT NULL
58 ) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_general_ci
59 DROP TABLE t1;
60 DROP DATABASE db1;
61 '------Check if load data uses character_set_database----------'
62 USE test;
63 CREATE TABLE t1 (a CHAR(4) CHARACTER SET utf8) ENGINE=MyISAM CHARACTER SET utf8;
64 'Verify with latin';
65 SET @@session.character_set_database = latin1;
66 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
67 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
68 count(*)
69 2433
70 TRUNCATE TABLE t1;
71 'Verify with utf8';
72 SET @@session.character_set_database = utf8;
73 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
74 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
75 count(*)
76 1
77 DROP TABLE IF EXISTS t1;
78 SET GLOBAL character_set_server=latin5;
79 connect con2, localhost, root,,;
80 connection con2;
81 CREATE DATABASE csdb CHARACTER SET = utf8;
82 USE csdb;
83 DROP DATABASE csdb;
84 SELECT @@character_set_database;
85 @@character_set_database
86 latin5
87 connection default;
88 disconnect con2;
89 SET @@global.collation_database = @global_collation_database;
90 SET @@session.collation_database = @session_collation_database;
91 SET @@session.collation_server = @session_collation_server;
92 SET @@global.collation_server = @global_collation_server;