1
'#--------------------FN_DYNVARS_015_01-------------------------#'
2
SET @global_collation_connection = @@global.collation_connection;
3
SET @session_collation_connection = @@session.collation_connection;
4
SET @@global.collation_connection = latin1_danish_ci;
5
'connect (con1,localhost,root,,,,)'
7
SELECT @@global.collation_connection;
8
@@global.collation_connection
10
SELECT @@session.collation_connection;
11
@@session.collation_connection
13
'#--------------------FN_DYNVARS_015_02-------------------------#'
15
DROP TABLE IF EXISTS t1;
16
'----check if collation_connection update character_set_connection---'
17
SET @@session.collation_connection = utf8_spanish_ci;
18
SELECT @@collation_connection, @@character_set_database;
19
@@collation_connection @@character_set_database
20
utf8_spanish_ci latin1
21
'---check if collation_connection works for literal string comparision--'
22
SET @@session.collation_connection = latin1_swedish_ci;
23
SELECT 'mysql'='MySql';
26
SELECT _latin2'mysql' COLLATE latin2_general_ci='MySql';
27
_latin2'mysql' COLLATE latin2_general_ci='MySql'
29
SELECT _utf8'mysql'=_utf8'MySql' COLLATE utf8_unicode_ci;
30
_utf8'mysql'=_utf8'MySql' COLLATE utf8_unicode_ci
32
SET @@session.collation_connection = latin1_general_cs;
33
SELECT 'mysql'='MySql';
36
SELECT _latin2'mysql'COLLATE latin2_general_ci='MySql';
37
_latin2'mysql'COLLATE latin2_general_ci='MySql'
39
SELECT _utf8'mysql'COLLATE utf8_danish_ci=_utf8'MySql'COLLATE utf8_unicode_ci;
40
ERROR HY000: Illegal mix of collations (utf8_danish_ci,EXPLICIT) and (utf8_unicode_ci,EXPLICIT) for operation '='
41
'---collation_connection does not effect comparision with column---'
42
CREATE TABLE t1(a CHAR(20)CHARACTER SET latin1 COLLATE latin1_german2_ci);
43
INSERT INTO t1 VALUES('M�ller');
44
SET @@session.collation_connection = latin2_hungarian_ci;
45
SELECT * FROM t1 WHERE a='M�ller';
48
SET @@session.collation_connection = latin1_general_cs;
49
SELECT * FROM t1 WHERE a='m�ller';
52
'check if string literal collation is used';
53
SELECT * FROM t1 WHERE a='m�ller' COLLATE latin1_general_cs;
55
SELECT * FROM t1 WHERE a='m�ller' COLLATE latin1_german1_ci;
59
SET @@global.collation_connection = @global_collation_connection;
60
SET @@session.collation_connection = @session_collation_connection;