Edit File: ctype_utf16_uca.result
DROP TABLE IF EXISTS t1; # # Start of 5.5 tests # set names utf8; set collation_connection=utf16_unicode_ci; select hex('a'), hex('a '); hex('a') hex('a ') 0061 00610020 select 'a' = 'a', 'a' = 'a ', 'a ' = 'a'; 'a' = 'a' 'a' = 'a ' 'a ' = 'a' 1 1 1 select 'a\0' = 'a', 'a\0' < 'a', 'a\0' > 'a'; 'a\0' = 'a' 'a\0' < 'a' 'a\0' > 'a' 1 0 0 select 'a' = 'a\0', 'a' < 'a\0', 'a' > 'a\0'; 'a' = 'a\0' 'a' < 'a\0' 'a' > 'a\0' 1 0 0 select 'a\0' = 'a ', 'a\0' < 'a ', 'a\0' > 'a '; 'a\0' = 'a ' 'a\0' < 'a ' 'a\0' > 'a ' 1 0 0 select 'a ' = 'a\0', 'a ' < 'a\0', 'a ' > 'a\0'; 'a ' = 'a\0' 'a ' < 'a\0' 'a ' > 'a\0' 1 0 0 select 'a a' > 'a', 'a \0' < 'a'; 'a a' > 'a' 'a \0' < 'a' 1 0 select binary 'a a' > 'a', binary 'a \0' > 'a', binary 'a\0' > 'a'; binary 'a a' > 'a' binary 'a \0' > 'a' binary 'a\0' > 'a' 1 1 1 select 'c' like '\_' as want0; want0 0 CREATE TABLE t ( c char(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARACTER SET utf16 COLLATE utf16_unicode_ci; INSERT INTO t VALUES ('a'),('ab'),('aba'); ALTER TABLE t ADD INDEX (c); SELECT c FROM t WHERE c LIKE 'a%'; c a ab aba DROP TABLE t; create table t1 (c1 char(10) character set utf16 collate utf16_bin); insert into t1 values ('A'),('a'); insert into t1 values ('B'),('b'); insert into t1 values ('C'),('c'); insert into t1 values ('D'),('d'); insert into t1 values ('E'),('e'); insert into t1 values ('F'),('f'); insert into t1 values ('G'),('g'); insert into t1 values ('H'),('h'); insert into t1 values ('I'),('i'); insert into t1 values ('J'),('j'); insert into t1 values ('K'),('k'); insert into t1 values ('L'),('l'); insert into t1 values ('M'),('m'); insert into t1 values ('N'),('n'); insert into t1 values ('O'),('o'); insert into t1 values ('P'),('p'); insert into t1 values ('Q'),('q'); insert into t1 values ('R'),('r'); insert into t1 values ('S'),('s'); insert into t1 values ('T'),('t'); insert into t1 values ('U'),('u'); insert into t1 values ('V'),('v'); insert into t1 values ('W'),('w'); insert into t1 values ('X'),('x'); insert into t1 values ('Y'),('y'); insert into t1 values ('Z'),('z'); insert into t1 values (0x00e0),(0x00c0); insert into t1 values (0x00e1),(0x00c1); insert into t1 values (0x00e2),(0x00c2); insert into t1 values (0x00e3),(0x00c3); insert into t1 values (0x00e4),(0x00c4); insert into t1 values (0x00e5),(0x00c5); insert into t1 values (0x00e6),(0x00c6); insert into t1 values (0x00e7),(0x00c7); insert into t1 values (0x00e8),(0x00c8); insert into t1 values (0x00e9),(0x00c9); insert into t1 values (0x00ea),(0x00ca); insert into t1 values (0x00eb),(0x00cb); insert into t1 values (0x00ec),(0x00cc); insert into t1 values (0x00ed),(0x00cd); insert into t1 values (0x00ee),(0x00ce); insert into t1 values (0x00ef),(0x00cf); insert into t1 values (0x00f0),(0x00d0); insert into t1 values (0x00f1),(0x00d1); insert into t1 values (0x00f2),(0x00d2); insert into t1 values (0x00f3),(0x00d3); insert into t1 values (0x00f4),(0x00d4); insert into t1 values (0x00f5),(0x00d5); insert into t1 values (0x00f6),(0x00d6); insert into t1 values (0x00f7),(0x00d7); insert into t1 values (0x00f8),(0x00d8); insert into t1 values (0x00f9),(0x00d9); insert into t1 values (0x00fa),(0x00da); insert into t1 values (0x00fb),(0x00db); insert into t1 values (0x00fc),(0x00dc); insert into t1 values (0x00fd),(0x00dd); insert into t1 values (0x00fe),(0x00de); insert into t1 values (0x00ff),(0x00df); insert into t1 values (0x0100),(0x0101),(0x0102),(0x0103); insert into t1 values (0x0104),(0x0105),(0x0106),(0x0107); insert into t1 values (0x0108),(0x0109),(0x010a),(0x010b); insert into t1 values (0x010c),(0x010d),(0x010e),(0x010f); insert into t1 values (0x0110),(0x0111),(0x0112),(0x0113); insert into t1 values (0x0114),(0x0115),(0x0116),(0x0117); insert into t1 values (0x0118),(0x0119),(0x011a),(0x011b); insert into t1 values (0x011c),(0x011d),(0x011e),(0x011f); insert into t1 values (0x0120),(0x0121),(0x0122),(0x0123); insert into t1 values (0x0124),(0x0125),(0x0126),(0x0127); insert into t1 values (0x0128),(0x0129),(0x012a),(0x012b); insert into t1 values (0x012c),(0x012d),(0x012e),(0x012f); insert into t1 values (0x0130),(0x0131),(0x0132),(0x0133); insert into t1 values (0x0134),(0x0135),(0x0136),(0x0137); insert into t1 values (0x0138),(0x0139),(0x013a),(0x013b); insert into t1 values (0x013c),(0x013d),(0x013e),(0x013f); insert into t1 values (0x0140),(0x0141),(0x0142),(0x0143); insert into t1 values (0x0144),(0x0145),(0x0146),(0x0147); insert into t1 values (0x0148),(0x0149),(0x014a),(0x014b); insert into t1 values (0x014c),(0x014d),(0x014e),(0x014f); insert into t1 values (0x0150),(0x0151),(0x0152),(0x0153); insert into t1 values (0x0154),(0x0155),(0x0156),(0x0157); insert into t1 values (0x0158),(0x0159),(0x015a),(0x015b); insert into t1 values (0x015c),(0x015d),(0x015e),(0x015f); insert into t1 values (0x0160),(0x0161),(0x0162),(0x0163); insert into t1 values (0x0164),(0x0165),(0x0166),(0x0167); insert into t1 values (0x0168),(0x0169),(0x016a),(0x016b); insert into t1 values (0x016c),(0x016d),(0x016e),(0x016f); insert into t1 values (0x0170),(0x0171),(0x0172),(0x0173); insert into t1 values (0x0174),(0x0175),(0x0176),(0x0177); insert into t1 values (0x0178),(0x0179),(0x017a),(0x017b); insert into t1 values (0x017c),(0x017d),(0x017e),(0x017f); insert into t1 values (0x0180),(0x0181),(0x0182),(0x0183); insert into t1 values (0x0184),(0x0185),(0x0186),(0x0187); insert into t1 values (0x0188),(0x0189),(0x018a),(0x018b); insert into t1 values (0x018c),(0x018d),(0x018e),(0x018f); insert into t1 values (0x0190),(0x0191),(0x0192),(0x0193); insert into t1 values (0x0194),(0x0195),(0x0196),(0x0197); insert into t1 values (0x0198),(0x0199),(0x019a),(0x019b); insert into t1 values (0x019c),(0x019d),(0x019e),(0x019f); insert into t1 values (0x01a0),(0x01a1),(0x01a2),(0x01a3); insert into t1 values (0x01a4),(0x01a5),(0x01a6),(0x01a7); insert into t1 values (0x01a8),(0x01a9),(0x01aa),(0x01ab); insert into t1 values (0x01ac),(0x01ad),(0x01ae),(0x01af); insert into t1 values (0x01b0),(0x01b1),(0x01b2),(0x01b3); insert into t1 values (0x01b4),(0x01b5),(0x01b6),(0x01b7); insert into t1 values (0x01b8),(0x01b9),(0x01ba),(0x01bb); insert into t1 values (0x01bc),(0x01bd),(0x01be),(0x01bf); insert into t1 values (0x01c0),(0x01c1),(0x01c2),(0x01c3); insert into t1 values (0x01c4),(0x01c5),(0x01c6),(0x01c7); insert into t1 values (0x01c8),(0x01c9),(0x01ca),(0x01cb); insert into t1 values (0x01cc),(0x01cd),(0x01ce),(0x01cf); insert into t1 values (0x01d0),(0x01d1),(0x01d2),(0x01d3); insert into t1 values (0x01d4),(0x01d5),(0x01d6),(0x01d7); insert into t1 values (0x01d8),(0x01d9),(0x01da),(0x01db); insert into t1 values (0x01dc),(0x01dd),(0x01de),(0x01df); insert into t1 values (0x01e0),(0x01e1),(0x01e2),(0x01e3); insert into t1 values (0x01e4),(0x01e5),(0x01e6),(0x01e7); insert into t1 values (0x01e8),(0x01e9),(0x01ea),(0x01eb); insert into t1 values (0x01ec),(0x01ed),(0x01ee),(0x01ef); insert into t1 values (0x01f0),(0x01f1),(0x01f2),(0x01f3); insert into t1 values (0x01f4),(0x01f5),(0x01f6),(0x01f7); insert into t1 values (0x01f8),(0x01f9),(0x01fa),(0x01fb); insert into t1 values (0x01fc),(0x01fd),(0x01fe),(0x01ff); insert into t1 values ('AA'),('Aa'),('aa'),('aA'); insert into t1 values ('CH'),('Ch'),('ch'),('cH'); insert into t1 values ('DZ'),('Dz'),('dz'),('dZ'); insert into t1 values ('IJ'),('Ij'),('ij'),('iJ'); insert into t1 values ('LJ'),('Lj'),('lj'),('lJ'); insert into t1 values ('LL'),('Ll'),('ll'),('lL'); insert into t1 values ('NJ'),('Nj'),('nj'),('nJ'); insert into t1 values ('OE'),('Oe'),('oe'),('oE'); insert into t1 values ('SS'),('Ss'),('ss'),('sS'); insert into t1 values ('RR'),('Rr'),('rr'),('rR'); select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_unicode_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_icelandic_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÂÃàâãĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa Áá ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Ðð Đđ Ɖ Ɗ Ƌƌ EeÈÊËèêëĒēĔĕĖėĘęĚě Éé Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÎÏìîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij Íí ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÔÕòôõŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ Óó Ǿǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÛÜùûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Úú Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÿŶŷŸ Ýý Ƴƴ ZzŹźŻżŽž ƍ Þþ ÄÆäæ ÖØöø Åå Ƶƶ ƷǮǯ Ƹƹ ƺ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_latvian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ CHChcHch Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġǦǧǴǵ Ģģ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij Yy ı Ɨ Ɩ JjĴĵǰ KkǨǩ Ķķ Ƙƙ LlĹ弾 Ŀŀ LJLjlJljLJLjlj LLLllLll Ļļ Łł ƚ ƛ Mm NnÑñŃńŇňǸǹ NJNjnJnjNJNjnj Ņņ Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŘř RRRrrRrr Ŗŗ Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx ÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_romanian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÃÄÅàáãäåĀāĄąǍǎǞǟǠǡǺǻ AAAaaAaa Ăă Ââ ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÏìíïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij Îî ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŠšſ SSSssSssß Şş Ʃ ƪ TtŤť ƾ Ţţ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_slovenian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ CHChcHch Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_polish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂăǍǎǞǟǠǡǺǻ AAAaaAaa Ąą ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĈĉĊċČč CHChcHch Ćć Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĚě Ęę Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŅņŇňǸǹ NJNjnJnjNJNjnj Ńń Ɲ ƞ Ŋŋ OoÒÔÕÖòôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ Óó ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŜŝŞşŠšſ SSSssSssß Śś Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŽž ƍ Źź Żż Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_estonian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdz DŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔòóôŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Zz Žž Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Õõ Ää Öö Üü Xx YyÝýÿŶŷŸ Ƴƴ ŹźŻż ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_spanish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ññ Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_swedish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃàáâãĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ Ǿǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÜÝüýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Åå ÄÆäæ ÖØöø Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_turkish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcĆćĈĉĊċČč CHChcHch Çç Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĠġĢģǦǧǴǵ Ğğ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ Iı IJIj ƕǶ Ħħ iÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ iJijIJij Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ Öö ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŠšſ SSSssSssß Şş Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Üü Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_czech_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ cH Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ CHChch ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗ RRRrrRrr Řř Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_danish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃàáâãĀāĂ㥹ǍǎǞǟǠǡǺǻ aA ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏƠơǑǒǪǫǬǭ OEOeoEoeŒœ Ǿǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÜÝüýÿŰűŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ ÄÆäæ ÖØöøŐő AAAaaaÅå Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_lithuanian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CCHChcchÇçĆćĈĉĊċ cH Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IYiyÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx ÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_slovak_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa Ää ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ cH Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ CHChch ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÕÖòóõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ Ôô ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_spanish2_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč cH CHChch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj lL LLLlll Łł ƚ ƛ Mm NnŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ññ Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_roman_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IJijÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJij IJij ı Ɨ Ɩ Ĵĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJlj LJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnj NJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ ÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ɯ Ʊ UVuv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_esperanto_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĊċČč CHChcHch Ĉĉ Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĞğĠġĢģǦǧǴǵ Ĝĝ Ǥǥ Ɠ Ɣ Ƣƣ Hh Ĥĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ Jjǰ Ĵĵ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŞşŠšſ SSSssSssß Ŝŝ Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ Ŭŭ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf16_hungarian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ AAAaaAaa ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚě Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏƠơǑǒǪǫǬǭ OEOeoEoeŒœ ÖöŐő ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŲųƯưǓǔǕǖǗǘǙǚǛǜ ÜüŰű Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ drop table t1; SET NAMES utf8; CREATE TABLE t1 (c varchar(200) CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_general_ci; c Μωδαί̈ INSERT INTO t1 VALUES (0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_general_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; CREATE TABLE t1 (c varchar(200) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci; c Μωδαί̈ INSERT INTO t1 VALUES (0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; CREATE TABLE t1 (c varchar(200) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci; c Μωδαί̈ INSERT INTO t1 VALUES (0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; SET NAMES utf8; SET @test_character_set='utf16'; SET @test_collation='utf16_swedish_ci'; SET @safe_character_set_server= @@character_set_server; SET @safe_collation_server= @@collation_server; SET @safe_character_set_client= @@character_set_client; SET @safe_character_set_results= @@character_set_results; SET character_set_server= @test_character_set; SET collation_server= @test_collation; CREATE DATABASE d1; USE d1; CREATE TABLE t1 (c CHAR(10), KEY(c)); SHOW FULL COLUMNS FROM t1; Field Type Collation Null Key Default Extra Privileges Comment c char(10) utf16_swedish_ci YES MUL NULL INSERT INTO t1 VALUES ('aaa'),('aaaa'),('aaaaa'); SELECT c as want3results FROM t1 WHERE c LIKE 'aaa%'; want3results aaa aaaa aaaaa DROP TABLE t1; CREATE TABLE t1 (c1 varchar(15), KEY c1 (c1(2))); SHOW FULL COLUMNS FROM t1; Field Type Collation Null Key Default Extra Privileges Comment c1 varchar(15) utf16_swedish_ci YES MUL NULL INSERT INTO t1 VALUES ('location'),('loberge'),('lotre'),('boabab'); SELECT c1 as want3results from t1 where c1 like 'l%'; want3results location loberge lotre SELECT c1 as want3results from t1 where c1 like 'lo%'; want3results location loberge lotre SELECT c1 as want1result from t1 where c1 like 'loc%'; want1result location SELECT c1 as want1result from t1 where c1 like 'loca%'; want1result location SELECT c1 as want1result from t1 where c1 like 'locat%'; want1result location SELECT c1 as want1result from t1 where c1 like 'locati%'; want1result location SELECT c1 as want1result from t1 where c1 like 'locatio%'; want1result location SELECT c1 as want1result from t1 where c1 like 'location%'; want1result location DROP TABLE t1; create table t1 (a set('a') not null); insert into t1 values (),(); Warnings: Warning 1364 Field 'a' doesn't have a default value select cast(a as char(1)) from t1; cast(a as char(1)) select a sounds like a from t1; a sounds like a 1 1 select 1 from t1 order by cast(a as char(1)); 1 1 1 drop table t1; set names utf8; create table t1 ( name varchar(10), level smallint unsigned); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `name` varchar(10) COLLATE utf16_swedish_ci DEFAULT NULL, `level` smallint(5) unsigned DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf16 COLLATE=utf16_swedish_ci insert into t1 values ('string',1); select concat(name,space(level)), concat(name, repeat(' ',level)) from t1; concat(name,space(level)) concat(name, repeat(' ',level)) string string drop table t1; DROP DATABASE d1; USE test; SET character_set_server= @safe_character_set_server; SET collation_server= @safe_collation_server; SET character_set_client= @safe_character_set_client; SET character_set_results= @safe_character_set_results; SET collation_connection='utf16_unicode_ci'; 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) utf16_unicode_ci 00610009 utf16_unicode_ci 0061 utf16_unicode_ci 00610020 drop table t1; select @@collation_connection; @@collation_connection utf16_unicode_ci create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ; insert into t1 values('abcdef'); insert into t1 values('_bcdef'); insert into t1 values('a_cdef'); insert into t1 values('ab_def'); insert into t1 values('abc_ef'); insert into t1 values('abcd_f'); insert into t1 values('abcde_'); select c1 as c1u from t1 where c1 like 'ab\_def'; c1u ab_def select c1 as c2h from t1 where c1 like 'ab#_def' escape '#'; c2h ab_def drop table t1; End of 4.1 tests CREATE TABLE t1 (id int, a varchar(30) character set utf16); INSERT INTO t1 VALUES (1, 0x01310069), (2, 0x01310131); INSERT INTO t1 VALUES (3, 0x00690069), (4, 0x01300049); INSERT INTO t1 VALUES (5, 0x01300130), (6, 0x00490049); SELECT a, length(a) la, @l:=lower(a) l, length(@l) ll, @u:=upper(a) u, length(@u) lu FROM t1 ORDER BY id; a la l ll u lu ıi 4 ıi 4 II 4 ıı 4 ıı 4 II 4 ii 4 ii 4 II 4 İI 4 ii 4 İI 4 İİ 4 ii 4 İİ 4 II 4 ii 4 II 4 ALTER TABLE t1 MODIFY a VARCHAR(30) character set utf16 collate utf16_turkish_ci; SELECT a, length(a) la, @l:=lower(a) l, length(@l) ll, @u:=upper(a) u, length(@u) lu FROM t1 ORDER BY id; a la l ll u lu ıi 4 ıi 4 Iİ 4 ıı 4 ıı 4 II 4 ii 4 ii 4 İİ 4 İI 4 iı 4 İI 4 İİ 4 ii 4 İİ 4 II 4 ıı 4 II 4 DROP TABLE t1; CREATE TABLE t1 ( c1 text character set utf16 collate utf16_polish_ci NOT NULL ) ENGINE=MyISAM; insert into t1 values (''),('a'); SELECT COUNT(*), c1 FROM t1 GROUP BY c1; COUNT(*) c1 1 1 a DROP TABLE IF EXISTS t1; set collation_connection=utf16_unicode_ci; drop table if exists t1; create table t1 as select repeat(' ', 64) as s1, repeat(' ',64) as s2 union select null, null; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `s1` varchar(64) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL, `s2` varchar(64) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 delete from t1; insert into t1 values('aaa','aaa'); insert into t1 values('aaa|qqq','qqq'); insert into t1 values('gheis','^[^a-dXYZ]+$'); insert into t1 values('aab','^aa?b'); insert into t1 values('Baaan','^Ba*n'); insert into t1 values('aaa','qqq|aaa'); insert into t1 values('qqq','qqq|aaa'); insert into t1 values('bbb','qqq|aaa'); insert into t1 values('bbb','qqq'); insert into t1 values('aaa','aba'); insert into t1 values(null,'abc'); insert into t1 values('def',null); insert into t1 values(null,null); insert into t1 values('ghi','ghi['); select HIGH_PRIORITY s1 regexp s2 from t1; s1 regexp s2 1 1 1 1 1 1 1 0 0 0 NULL NULL NULL NULL drop table t1; SET collation_connection=utf16_czech_ci; SELECT @@collation_connection; @@collation_connection utf16_czech_ci # # Bug#57737 Character sets: search fails with like, contraction, index # CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0; INSERT INTO t1 VALUES ('c'),('ce'),('cé'),('ch'); SELECT * FROM t1 WHERE s1 LIKE 'c%'; s1 c ce cé ch ALTER TABLE t1 ADD KEY s1 (s1); SELECT * FROM t1 WHERE s1 LIKE 'c%'; s1 c ce cé ch ALTER TABLE t1 DROP KEY s1, ADD KEY(s1(1)); SELECT * FROM t1 WHERE s1 LIKE 'ch'; s1 ch DROP TABLE t1; SELECT @@collation_connection; @@collation_connection utf16_czech_ci # # Bug#57737 Character sets: search fails with like, contraction, index # Part#2 - ignorable characters # CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0; INSERT INTO t1 VALUES ('a\0\0\0\0\0\t'),('a'),('b'),('c'),('d'),('e'); SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%'; HEX(s1) 0061000000000000000000000009 0061 ALTER TABLE t1 ADD KEY s1 (s1); SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%'; HEX(s1) 0061000000000000000000000009 0061 DROP TABLE t1; # # End of 5.5 tests #
Back to File Manager