1'#--------------------FN_DYNVARS_014_01-------------------------#'
2SET @global_collation_server = @@global.collation_server;
3SET @session_collation_server = @@session.collation_server;
4SET @@global.collation_server = latin1_danish_ci;
5connect  con1,localhost,root,,,,;
6connection con1;
7SELECT @@global.collation_server;
8@@global.collation_server
9latin1_danish_ci
10SELECT @@session.collation_server;
11@@session.collation_server
12latin1_danish_ci
13disconnect con1;
14'#--------------------FN_DYNVARS_014_02-------------------------#'
15connection default;
16DROP TABLE IF EXISTS t1,t2;
17'---check if setting collation_server update character_set_server---'
18SET @@session.collation_server = utf8_spanish_ci;
19SELECT @@collation_server, @@character_set_server;
20@@collation_server	@@character_set_server
21utf8_spanish_ci	utf8
22'--check if collation_server effects database/table charset/collation--'
23SET @@session.collation_server = latin1_german1_ci;
24CREATE DATABASE db1;
25USE db1;
26SHOW CREATE DATABASE db1;
27Database	Create Database
28db1	CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci */
29CREATE TABLE t1(a CHAR(20));
30SHOW CREATE TABLE t1;
31Table	Create Table
32t1	CREATE TABLE `t1` (
33  `a` char(20) COLLATE latin1_german1_ci DEFAULT NULL
34) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci
35'---check if updating collation_server effects new table/column---'
36SET @@session.collation_server = latin1_swedish_ci;
37CREATE TABLE t2(a CHAR(10));
38SHOW CREATE TABLE t2;
39Table	Create Table
40t2	CREATE TABLE `t2` (
41  `a` char(10) COLLATE latin1_german1_ci DEFAULT NULL
42) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci
43INSERT INTO t1 VALUES('Muffler'),('M�ller'),('MX Systems');
44'---check if collation_server effects results sort order---'
45SET @@session.collation_server = latin1_swedish_ci;
46SELECT * FROM t1 ORDER BY a;
47a
48Muffler
49M�ller
50MX Systems
51SET @@session.collation_server = latin1_german1_ci;
52SELECT * FROM t1 ORDER BY a;
53a
54Muffler
55M�ller
56MX Systems
57SELECT * FROM t1 ORDER BY a COLLATE latin1_swedish_ci;
58a
59Muffler
60MX Systems
61M�ller
62SELECT * FROM t1 ORDER BY a COLLATE latin1_german1_ci;
63a
64Muffler
65M�ller
66MX Systems
67'---check if indexing is effected by collation_server---'
68SET @@session.collation_server = latin1_swedish_ci;
69ALTER TABLE t1 ADD PRIMARY KEY (a);
70REPAIR TABLE t1;
71Table	Op	Msg_type	Msg_text
72db1.t1	repair	status	OK
73SELECT * FROM t1 ORDER BY a;
74a
75Muffler
76M�ller
77MX Systems
78ALTER TABLE t1 DROP PRIMARY KEY;
79SET @@session.collation_server = latin1_german1_ci;
80ALTER TABLE t1 ADD PRIMARY KEY (a);
81REPAIR TABLE t1;
82Table	Op	Msg_type	Msg_text
83db1.t1	repair	status	OK
84SELECT * FROM t1 ORDER BY a;
85a
86Muffler
87M�ller
88MX Systems
89DROP TABLE t1,t2;
90DROP DATABASE db1;
91SET @@global.collation_server = @global_collation_server;
92SET @@session.collation_server = @session_collation_server;
93