⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
sys_vars
/
r
/
View File Name :
collation_connection_func.result
'#--------------------FN_DYNVARS_015_01-------------------------#' SET @global_collation_connection = @@global.collation_connection; SET @session_collation_connection = @@session.collation_connection; SET @@global.collation_connection = latin1_danish_ci; 'connect (con1,localhost,root,,,,)' 'connection con1' SELECT @@global.collation_connection; @@global.collation_connection latin1_danish_ci SELECT @@session.collation_connection; @@session.collation_connection latin1_danish_ci '#--------------------FN_DYNVARS_015_02-------------------------#' 'connection default' DROP TABLE IF EXISTS t1; '----check if collation_connection update character_set_connection---' SET @@session.collation_connection = utf8_spanish_ci; SELECT @@collation_connection, @@character_set_database; @@collation_connection @@character_set_database utf8_spanish_ci latin1 '---check if collation_connection works for literal string comparision--' SET @@session.collation_connection = latin1_swedish_ci; SELECT 'mysql'='MySql'; 'mysql'='MySql' 1 SELECT _latin2'mysql' COLLATE latin2_general_ci='MySql'; _latin2'mysql' COLLATE latin2_general_ci='MySql' 1 SELECT _utf8'mysql'=_utf8'MySql' COLLATE utf8_unicode_ci; _utf8'mysql'=_utf8'MySql' COLLATE utf8_unicode_ci 1 SET @@session.collation_connection = latin1_general_cs; SELECT 'mysql'='MySql'; 'mysql'='MySql' 0 SELECT _latin2'mysql'COLLATE latin2_general_ci='MySql'; _latin2'mysql'COLLATE latin2_general_ci='MySql' 1 SELECT _utf8'mysql'COLLATE utf8_danish_ci=_utf8'MySql'COLLATE utf8_unicode_ci; ERROR HY000: Illegal mix of collations (utf8_danish_ci,EXPLICIT) and (utf8_unicode_ci,EXPLICIT) for operation '=' '---collation_connection does not effect comparision with column---' CREATE TABLE t1(a CHAR(20)CHARACTER SET latin1 COLLATE latin1_german2_ci); INSERT INTO t1 VALUES('M�ller'); SET @@session.collation_connection = latin2_hungarian_ci; SELECT * FROM t1 WHERE a='M�ller'; a M�ller SET @@session.collation_connection = latin1_general_cs; SELECT * FROM t1 WHERE a='m�ller'; a M�ller 'check if string literal collation is used'; SELECT * FROM t1 WHERE a='m�ller' COLLATE latin1_general_cs; a SELECT * FROM t1 WHERE a='m�ller' COLLATE latin1_german1_ci; a M�ller DROP TABLE t1; SET @@global.collation_connection = @global_collation_connection; SET @@session.collation_connection = @session_collation_connection;