⚝
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
/
r
/
View File Name :
ctype_latin1_de.result
set names latin1; set @@collation_connection=latin1_german2_ci; select @@collation_connection; @@collation_connection latin1_german2_ci drop table if exists t1; create table t1 (a char (20) not null, b int not null auto_increment, index (a,b)); insert into t1 (a) values ('�'),('ac'),('ae'),('ad'),('�c'),('aeb'); insert into t1 (a) values ('�c'),('uc'),('ue'),('ud'),('�'),('ueb'),('uf'); insert into t1 (a) values ('�'),('oc'),('�a'),('oe'),('od'),('�c'),('oeb'); insert into t1 (a) values ('s'),('ss'),('�'),('�b'),('ssa'),('ssc'),('�a'); insert into t1 (a) values ('e�'),('u�'),('�o'),('��'),('��a'),('aeae'); insert into t1 (a) values ('q'),('a'),('u'),('o'),('�'),('�'),('a'); select a,b from t1 order by a,b; a b a 1 a 2 ac 1 ad 1 � 1 ae 2 �� 1 aeae 2 ��a 1 aeb 1 �c 1 � 1 � 2 e� 1 o 1 oc 1 od 1 � 1 oe 2 �a 1 oeb 1 �c 1 �o 1 q 1 s 1 ss 1 � 2 ssa 1 �a 2 �b 1 ssc 1 u 1 uc 1 ud 1 ue 1 � 2 ueb 1 �c 1 uf 1 u� 1 select a,b from t1 order by upper(a),b; a b a 1 a 2 ac 1 ad 1 � 1 ae 2 �� 1 aeae 2 ��a 1 aeb 1 �c 1 � 1 � 2 e� 1 o 1 oc 1 od 1 � 1 oe 2 �a 1 oeb 1 �c 1 �o 1 q 1 s 1 ss 1 � 2 ssa 1 �a 2 �b 1 ssc 1 u 1 uc 1 ud 1 ue 1 � 2 ueb 1 �c 1 uf 1 u� 1 select a from t1 order by a desc; a u� uf �c ueb � ue ud uc u ssc �b �a ssa � ss s q �o �c oeb �a oe � od oc o e� � � �c aeb ��a aeae �� ae � ad ac a a check table t1; Table Op Msg_type Msg_text test.t1 check status OK select * from t1 where a like "�%"; a b � 1 �a 1 �c 1 �o 1 select * from t1 where a like binary "%�%"; a b � 2 select * from t1 where a like "%�%"; a b a 1 a 2 ac 1 ad 1 ae 2 aeae 2 ��a 1 aeb 1 �a 1 ssa 1 �a 2 select * from t1 where a like "%U%"; a b u 1 uc 1 ud 1 ue 1 ueb 1 uf 1 u� 1 select * from t1 where a like "%ss%"; a b ss 1 ssa 1 ssc 1 drop table t1; select strcmp('�','ae'),strcmp('ae','�'),strcmp('aeq','�q'),strcmp('�q','aeq'); strcmp('�','ae') strcmp('ae','�') strcmp('aeq','�q') strcmp('�q','aeq') 0 0 0 0 select strcmp('ss','�'),strcmp('�','ss'),strcmp('�s','sss'),strcmp('�q','ssq'); strcmp('ss','�') strcmp('�','ss') strcmp('�s','sss') strcmp('�q','ssq') 0 0 0 0 select strcmp('�','af'),strcmp('a','�'),strcmp('��','aeq'),strcmp('��','aeaeq'); strcmp('�','af') strcmp('a','�') strcmp('��','aeq') strcmp('��','aeaeq') -1 -1 -1 -1 select strcmp('ss','�a'),strcmp('�','ssa'),strcmp('s�a','sssb'),strcmp('s','�'); strcmp('ss','�a') strcmp('�','ssa') strcmp('s�a','sssb') strcmp('s','�') -1 -1 -1 -1 select strcmp('�','o�'),strcmp('�','u�'),strcmp('�','oeb'); strcmp('�','o�') strcmp('�','u�') strcmp('�','oeb') -1 -1 -1 select strcmp('af','�'),strcmp('�','a'),strcmp('aeq','��'),strcmp('aeaeq','��'); strcmp('af','�') strcmp('�','a') strcmp('aeq','��') strcmp('aeaeq','��') 1 1 1 1 select strcmp('�a','ss'),strcmp('ssa','�'),strcmp('sssb','s�a'),strcmp('�','s'); strcmp('�a','ss') strcmp('ssa','�') strcmp('sssb','s�a') strcmp('�','s') 1 1 1 1 select strcmp('u','�a'),strcmp('u','�'); strcmp('u','�a') strcmp('u','�') 1 1 select strcmp('s�', '�a'), strcmp('a�', '�x'); strcmp('s�', '�a') strcmp('a�', '�x') -1 -1 create table t1 (a varchar(10), key(a), fulltext (a)); insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test"); select * from t1 where a like "abc%"; a abc abcd select * from t1 where a like "test%"; a test select * from t1 where a like "te_t"; a test select * from t1 where match a against ("te*" in boolean mode)+0; a test drop table t1; create table t1 (word varchar(255) not null, word2 varchar(255) not null default '', index(word)); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `word` varchar(255) COLLATE latin1_german2_ci NOT NULL, `word2` varchar(255) COLLATE latin1_german2_ci NOT NULL DEFAULT '', KEY `word` (`word`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci insert into t1 (word) values ('ss'),(0xDF),(0xE4),('ae'); update t1 set word2=word; select word, word=binary 0xdf as t from t1 having t > 0; word t � 1 select word, word=cast(0xdf AS CHAR) as t from t1 having t > 0; word t ss 1 � 1 select * from t1 where word=binary 0xDF; word word2 � � select * from t1 where word=CAST(0xDF as CHAR); word word2 ss ss � � select * from t1 where word2=binary 0xDF; word word2 � � select * from t1 where word2=CAST(0xDF as CHAR); word word2 ss ss � � select * from t1 where word='ae'; word word2 � � ae ae select * from t1 where word= 0xe4 or word=CAST(0xe4 as CHAR); word word2 � � ae ae select * from t1 where word between binary 0xDF and binary 0xDF; word word2 � � select * from t1 where word between CAST(0xDF AS CHAR) and CAST(0xDF AS CHAR); word word2 ss ss � � select * from t1 where word like 'ae'; word word2 ae ae select * from t1 where word like 'AE'; word word2 ae ae select * from t1 where word like binary 0xDF; word word2 � � select * from t1 where word like CAST(0xDF as CHAR); word word2 � � drop table t1; CREATE TABLE t1 ( autor varchar(80) NOT NULL default '', PRIMARY KEY (autor) ); INSERT INTO t1 VALUES ('Powell, B.'),('Powell, Bud.'),('Powell, L. H.'),('Power, H.'), ('Poynter, M. A. L. Lane'),('Poynting, J. H. und J. J. Thomson.'),('Pozzi, S(amuel-Jean).'), ('Pozzi, Samuel-Jean.'),('Pozzo, A.'),('Pozzoli, Serge.'); SELECT * FROM t1 WHERE autor LIKE 'Poz%' ORDER BY autor; autor Pozzi, S(amuel-Jean). Pozzi, Samuel-Jean. Pozzo, A. Pozzoli, Serge. DROP TABLE t1; CREATE TABLE t1 ( s1 CHAR(5) CHARACTER SET latin1 COLLATE latin1_german2_ci ); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `s1` char(5) COLLATE latin1_german2_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci INSERT INTO t1 VALUES ('�'); INSERT INTO t1 VALUES ('ue'); SELECT DISTINCT s1 FROM t1; s1 � SELECT s1,COUNT(*) FROM t1 GROUP BY s1; s1 COUNT(*) � 2 SELECT COUNT(DISTINCT s1) FROM t1; COUNT(DISTINCT s1) 1 SELECT FIELD('ue',s1), FIELD('�',s1), s1='ue', s1='�' FROM t1; FIELD('ue',s1) FIELD('�',s1) s1='ue' s1='�' 1 1 1 1 1 1 1 1 DROP TABLE t1; create table t1 select repeat('a',4000) a; delete from t1; insert into t1 values ('a'), ('a '), ('a\t'); select collation(a),hex(a) from t1 order by a; collation(a) hex(a) latin1_german2_ci 6109 latin1_german2_ci 61 latin1_german2_ci 6120 drop table t1; "BEGIN ctype_german.inc" drop table if exists t1; create table t1 as select repeat(' ', 64) as s1; select collation(s1) from t1; collation(s1) latin1_german2_ci delete from t1; INSERT INTO t1 VALUES ('ud'),('uf'); INSERT INTO t1 VALUES ('od'),('of'); INSERT INTO t1 VALUES ('e'); INSERT INTO t1 VALUES ('ad'),('af'); insert into t1 values ('a'),('ae'),(_latin1 0xE4); insert into t1 values ('o'),('oe'),(_latin1 0xF6); insert into t1 values ('s'),('ss'),(_latin1 0xDF); insert into t1 values ('u'),('ue'),(_latin1 0xFC); INSERT INTO t1 VALUES (_latin1 0xE6), (_latin1 0xC6); INSERT INTO t1 VALUES (_latin1 0x9C), (_latin1 0x8C); select s1, hex(s1) from t1 order by s1, binary s1; s1 hex(s1) a 61 ad 6164 ae 6165 � E4 af 6166 e 65 o 6F od 6F64 oe 6F65 � F6 of 6F66 s 73 ss 7373 � DF u 75 ud 7564 ue 7565 � FC uf 7566 � C6 � E6 � 8C � 9C select group_concat(s1 order by binary s1) from t1 group by s1; group_concat(s1 order by binary s1) a ad ae,� af e o od oe,� of s ss,� u ud ue,� uf �,� � � SELECT s1, hex(s1), hex(weight_string(s1)) FROM t1 ORDER BY s1, BINARY(s1); s1 hex(s1) hex(weight_string(s1)) a 61 41 ad 6164 4144 ae 6165 4145 � E4 4145 af 6166 4146 e 65 45 o 6F 4F od 6F64 4F44 oe 6F65 4F45 � F6 4F45 of 6F66 4F46 s 73 53 ss 7373 5353 � DF 5353 u 75 55 ud 7564 5544 ue 7565 5545 � FC 5545 uf 7566 5546 � C6 5C � E6 5C � 8C 8C � 9C 9C SELECT s1, hex(s1) FROM t1 WHERE s1='ae' ORDER BY s1, BINARY(s1); s1 hex(s1) ae 6165 � E4 drop table t1; "END ctype_german.inc" SET NAMES latin1; CREATE TABLE t1 ( col1 varchar(255) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 collate latin1_german2_ci; INSERT INTO t1 VALUES ('�'),('ss'),('ss'); ALTER TABLE t1 ADD KEY ifword(col1); SELECT * FROM t1 WHERE col1='�' ORDER BY col1, BINARY col1; col1 ss ss � DROP TABLE t1; create table t1 (s1 char(5) character set latin1 collate latin1_german2_ci); insert into t1 values (0xf6) /* this is o-umlaut */; select * from t1 where length(s1)=1 and s1='oe'; s1 � drop table t1; End of 5.1 tests # # Start of 5.6 tests # # # WL#3664 WEIGHT_STRING # set @@collation_connection=latin1_german2_ci; select @@collation_connection; @@collation_connection latin1_german2_ci select hex(weight_string('a')); hex(weight_string('a')) 41 select hex(weight_string('A')); hex(weight_string('A')) 41 select hex(weight_string('abc')); hex(weight_string('abc')) 414243 select hex(weight_string('abc' as char(2))); hex(weight_string('abc' as char(2))) 4142 select hex(weight_string('abc' as char(3))); hex(weight_string('abc' as char(3))) 414243 select hex(weight_string('abc' as char(5))); hex(weight_string('abc' as char(5))) 4142432020 select hex(weight_string('abc', 1, 2, 0xC0)); hex(weight_string('abc', 1, 2, 0xC0)) 41 select hex(weight_string('abc', 2, 2, 0xC0)); hex(weight_string('abc', 2, 2, 0xC0)) 4142 select hex(weight_string('abc', 3, 2, 0xC0)); hex(weight_string('abc', 3, 2, 0xC0)) 414220 select hex(weight_string('abc', 4, 2, 0xC0)); hex(weight_string('abc', 4, 2, 0xC0)) 41422020 select hex(weight_string('abc', 5, 2, 0xC0)); hex(weight_string('abc', 5, 2, 0xC0)) 4142202020 select hex(weight_string('abc',25, 2, 0xC0)); hex(weight_string('abc',25, 2, 0xC0)) 41422020202020202020202020202020202020202020202020 select hex(weight_string('abc', 1, 3, 0xC0)); hex(weight_string('abc', 1, 3, 0xC0)) 41 select hex(weight_string('abc', 2, 3, 0xC0)); hex(weight_string('abc', 2, 3, 0xC0)) 4142 select hex(weight_string('abc', 3, 3, 0xC0)); hex(weight_string('abc', 3, 3, 0xC0)) 414243 select hex(weight_string('abc', 4, 3, 0xC0)); hex(weight_string('abc', 4, 3, 0xC0)) 41424320 select hex(weight_string('abc', 5, 3, 0xC0)); hex(weight_string('abc', 5, 3, 0xC0)) 4142432020 select hex(weight_string('abc',25, 3, 0xC0)); hex(weight_string('abc',25, 3, 0xC0)) 41424320202020202020202020202020202020202020202020 select hex(weight_string('abc', 1, 4, 0xC0)); hex(weight_string('abc', 1, 4, 0xC0)) 41 select hex(weight_string('abc', 2, 4, 0xC0)); hex(weight_string('abc', 2, 4, 0xC0)) 4142 select hex(weight_string('abc', 3, 4, 0xC0)); hex(weight_string('abc', 3, 4, 0xC0)) 414243 select hex(weight_string('abc', 4, 4, 0xC0)); hex(weight_string('abc', 4, 4, 0xC0)) 41424320 select hex(weight_string('abc', 5, 4, 0xC0)); hex(weight_string('abc', 5, 4, 0xC0)) 4142432020 select hex(weight_string('abc',25, 4, 0xC0)); hex(weight_string('abc',25, 4, 0xC0)) 41424320202020202020202020202020202020202020202020 select @@collation_connection; @@collation_connection latin1_german2_ci select hex(weight_string(cast(_latin1 0x80 as char))); hex(weight_string(cast(_latin1 0x80 as char))) 80 select hex(weight_string(cast(_latin1 0x808080 as char))); hex(weight_string(cast(_latin1 0x808080 as char))) 808080 select hex(weight_string(cast(_latin1 0x808080 as char) as char(2))); hex(weight_string(cast(_latin1 0x808080 as char) as char(2))) 8080 select hex(weight_string(cast(_latin1 0x808080 as char) as char(3))); hex(weight_string(cast(_latin1 0x808080 as char) as char(3))) 808080 select hex(weight_string(cast(_latin1 0x808080 as char) as char(5))); hex(weight_string(cast(_latin1 0x808080 as char) as char(5))) 8080802020 select hex(weight_string(cast(_latin1 0x808080 as char), 1, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 1, 2, 0xC0)) 80 select hex(weight_string(cast(_latin1 0x808080 as char), 2, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 2, 2, 0xC0)) 8080 select hex(weight_string(cast(_latin1 0x808080 as char), 3, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 3, 2, 0xC0)) 808020 select hex(weight_string(cast(_latin1 0x808080 as char), 4, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 4, 2, 0xC0)) 80802020 select hex(weight_string(cast(_latin1 0x808080 as char), 5, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 5, 2, 0xC0)) 8080202020 select hex(weight_string(cast(_latin1 0x808080 as char),25, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char),25, 2, 0xC0)) 80802020202020202020202020202020202020202020202020 select hex(weight_string(cast(_latin1 0x808080 as char), 1, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 1, 3, 0xC0)) 80 select hex(weight_string(cast(_latin1 0x808080 as char), 2, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 2, 3, 0xC0)) 8080 select hex(weight_string(cast(_latin1 0x808080 as char), 3, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 3, 3, 0xC0)) 808080 select hex(weight_string(cast(_latin1 0x808080 as char), 4, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 4, 3, 0xC0)) 80808020 select hex(weight_string(cast(_latin1 0x808080 as char), 5, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 5, 3, 0xC0)) 8080802020 select hex(weight_string(cast(_latin1 0x808080 as char),25, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char),25, 3, 0xC0)) 80808020202020202020202020202020202020202020202020 select hex(weight_string(cast(_latin1 0x808080 as char), 1, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 1, 4, 0xC0)) 80 select hex(weight_string(cast(_latin1 0x808080 as char), 2, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 2, 4, 0xC0)) 8080 select hex(weight_string(cast(_latin1 0x808080 as char), 3, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 3, 4, 0xC0)) 808080 select hex(weight_string(cast(_latin1 0x808080 as char), 4, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 4, 4, 0xC0)) 80808020 select hex(weight_string(cast(_latin1 0x808080 as char), 5, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 5, 4, 0xC0)) 8080802020 select hex(weight_string(cast(_latin1 0x808080 as char),25, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char),25, 4, 0xC0)) 80808020202020202020202020202020202020202020202020 select @@collation_connection; @@collation_connection latin1_german2_ci select hex(weight_string('a' LEVEL 1)); hex(weight_string('a' LEVEL 1)) 41 select hex(weight_string('A' LEVEL 1)); hex(weight_string('A' LEVEL 1)) 41 select hex(weight_string('abc' LEVEL 1)); hex(weight_string('abc' LEVEL 1)) 414243 select hex(weight_string('abc' as char(2) LEVEL 1)); hex(weight_string('abc' as char(2) LEVEL 1)) 4142 select hex(weight_string('abc' as char(3) LEVEL 1)); hex(weight_string('abc' as char(3) LEVEL 1)) 414243 select hex(weight_string('abc' as char(5) LEVEL 1)); hex(weight_string('abc' as char(5) LEVEL 1)) 4142432020 select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)) 2020434241 select hex(weight_string('abc' as char(5) LEVEL 1 DESC)); hex(weight_string('abc' as char(5) LEVEL 1 DESC)) BEBDBCDFDF select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)) DFDFBCBDBE select hex(weight_string('�')); hex(weight_string('�')) 4145 select hex(weight_string('�')); hex(weight_string('�')) 4145 select hex(weight_string('�')); hex(weight_string('�')) 4F45 select hex(weight_string('�')); hex(weight_string('�')) 4F45 select hex(weight_string('�')); hex(weight_string('�')) 5545 select hex(weight_string('�')); hex(weight_string('�')) 5545 select hex(weight_string('S')); hex(weight_string('S')) 53 select hex(weight_string('s')); hex(weight_string('s')) 53 select hex(weight_string('�')); hex(weight_string('�')) 5353 select hex(weight_string('�' as char(1))); hex(weight_string('�' as char(1))) 41 select hex(weight_string('�' as char(1))); hex(weight_string('�' as char(1))) 4F select hex(weight_string('�' as char(1))); hex(weight_string('�' as char(1))) 55 select hex(weight_string('�' as char(1))); hex(weight_string('�' as char(1))) 53 select hex(weight_string('x�' as char(2))); hex(weight_string('x�' as char(2))) 5841 select hex(weight_string('x�' as char(2))); hex(weight_string('x�' as char(2))) 584F select hex(weight_string('x�' as char(2))); hex(weight_string('x�' as char(2))) 5855 select hex(weight_string('x�' as char(2))); hex(weight_string('x�' as char(2))) 5853 # # End of 5.6 tests #