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