1
DROP TABLE IF EXISTS t1;
3
set collation_connection=utf32_unicode_ci;
4
select hex('a'), hex('a ');
6
00000061 0000006100000020
7
select 'a' = 'a', 'a' = 'a ', 'a ' = 'a';
8
'a' = 'a' 'a' = 'a ' 'a ' = 'a'
10
select 'a\0' = 'a', 'a\0' < 'a', 'a\0' > 'a';
11
'a\0' = 'a' 'a\0' < 'a' 'a\0' > 'a'
13
select 'a' = 'a\0', 'a' < 'a\0', 'a' > 'a\0';
14
'a' = 'a\0' 'a' < 'a\0' 'a' > 'a\0'
16
select 'a\0' = 'a ', 'a\0' < 'a ', 'a\0' > 'a ';
17
'a\0' = 'a ' 'a\0' < 'a ' 'a\0' > 'a '
19
select 'a ' = 'a\0', 'a ' < 'a\0', 'a ' > 'a\0';
20
'a ' = 'a\0' 'a ' < 'a\0' 'a ' > 'a\0'
22
select 'a a' > 'a', 'a \0' < 'a';
23
'a a' > 'a' 'a \0' < 'a'
25
select binary 'a a' > 'a', binary 'a \0' > 'a', binary 'a\0' > 'a';
26
binary 'a a' > 'a' binary 'a \0' > 'a' binary 'a\0' > 'a'
28
select 'c' like '\_' as want0;
33
) ENGINE=MyISAM DEFAULT CHARACTER SET utf32 COLLATE=utf32_unicode_ci;
34
INSERT INTO t VALUES ('a'),('ab'),('aba');
35
ALTER TABLE t ADD INDEX (c);
36
SELECT c FROM t WHERE c LIKE 'a%';
42
create table t1 (c1 char(10) character set utf32 collate utf32_bin);
43
insert into t1 values ('A'),('a');
44
insert into t1 values ('B'),('b');
45
insert into t1 values ('C'),('c');
46
insert into t1 values ('D'),('d');
47
insert into t1 values ('E'),('e');
48
insert into t1 values ('F'),('f');
49
insert into t1 values ('G'),('g');
50
insert into t1 values ('H'),('h');
51
insert into t1 values ('I'),('i');
52
insert into t1 values ('J'),('j');
53
insert into t1 values ('K'),('k');
54
insert into t1 values ('L'),('l');
55
insert into t1 values ('M'),('m');
56
insert into t1 values ('N'),('n');
57
insert into t1 values ('O'),('o');
58
insert into t1 values ('P'),('p');
59
insert into t1 values ('Q'),('q');
60
insert into t1 values ('R'),('r');
61
insert into t1 values ('S'),('s');
62
insert into t1 values ('T'),('t');
63
insert into t1 values ('U'),('u');
64
insert into t1 values ('V'),('v');
65
insert into t1 values ('W'),('w');
66
insert into t1 values ('X'),('x');
67
insert into t1 values ('Y'),('y');
68
insert into t1 values ('Z'),('z');
69
insert into t1 values (_ucs2 0x00e0),(_ucs2 0x00c0);
70
insert into t1 values (_ucs2 0x00e1),(_ucs2 0x00c1);
71
insert into t1 values (_ucs2 0x00e2),(_ucs2 0x00c2);
72
insert into t1 values (_ucs2 0x00e3),(_ucs2 0x00c3);
73
insert into t1 values (_ucs2 0x00e4),(_ucs2 0x00c4);
74
insert into t1 values (_ucs2 0x00e5),(_ucs2 0x00c5);
75
insert into t1 values (_ucs2 0x00e6),(_ucs2 0x00c6);
76
insert into t1 values (_ucs2 0x00e7),(_ucs2 0x00c7);
77
insert into t1 values (_ucs2 0x00e8),(_ucs2 0x00c8);
78
insert into t1 values (_ucs2 0x00e9),(_ucs2 0x00c9);
79
insert into t1 values (_ucs2 0x00ea),(_ucs2 0x00ca);
80
insert into t1 values (_ucs2 0x00eb),(_ucs2 0x00cb);
81
insert into t1 values (_ucs2 0x00ec),(_ucs2 0x00cc);
82
insert into t1 values (_ucs2 0x00ed),(_ucs2 0x00cd);
83
insert into t1 values (_ucs2 0x00ee),(_ucs2 0x00ce);
84
insert into t1 values (_ucs2 0x00ef),(_ucs2 0x00cf);
85
insert into t1 values (_ucs2 0x00f0),(_ucs2 0x00d0);
86
insert into t1 values (_ucs2 0x00f1),(_ucs2 0x00d1);
87
insert into t1 values (_ucs2 0x00f2),(_ucs2 0x00d2);
88
insert into t1 values (_ucs2 0x00f3),(_ucs2 0x00d3);
89
insert into t1 values (_ucs2 0x00f4),(_ucs2 0x00d4);
90
insert into t1 values (_ucs2 0x00f5),(_ucs2 0x00d5);
91
insert into t1 values (_ucs2 0x00f6),(_ucs2 0x00d6);
92
insert into t1 values (_ucs2 0x00f7),(_ucs2 0x00d7);
93
insert into t1 values (_ucs2 0x00f8),(_ucs2 0x00d8);
94
insert into t1 values (_ucs2 0x00f9),(_ucs2 0x00d9);
95
insert into t1 values (_ucs2 0x00fa),(_ucs2 0x00da);
96
insert into t1 values (_ucs2 0x00fb),(_ucs2 0x00db);
97
insert into t1 values (_ucs2 0x00fc),(_ucs2 0x00dc);
98
insert into t1 values (_ucs2 0x00fd),(_ucs2 0x00dd);
99
insert into t1 values (_ucs2 0x00fe),(_ucs2 0x00de);
100
insert into t1 values (_ucs2 0x00ff),(_ucs2 0x00df);
101
insert into t1 values (_ucs2 0x0100),(_ucs2 0x0101),(_ucs2 0x0102),(_ucs2 0x0103);
102
insert into t1 values (_ucs2 0x0104),(_ucs2 0x0105),(_ucs2 0x0106),(_ucs2 0x0107);
103
insert into t1 values (_ucs2 0x0108),(_ucs2 0x0109),(_ucs2 0x010a),(_ucs2 0x010b);
104
insert into t1 values (_ucs2 0x010c),(_ucs2 0x010d),(_ucs2 0x010e),(_ucs2 0x010f);
105
insert into t1 values (_ucs2 0x0110),(_ucs2 0x0111),(_ucs2 0x0112),(_ucs2 0x0113);
106
insert into t1 values (_ucs2 0x0114),(_ucs2 0x0115),(_ucs2 0x0116),(_ucs2 0x0117);
107
insert into t1 values (_ucs2 0x0118),(_ucs2 0x0119),(_ucs2 0x011a),(_ucs2 0x011b);
108
insert into t1 values (_ucs2 0x011c),(_ucs2 0x011d),(_ucs2 0x011e),(_ucs2 0x011f);
109
insert into t1 values (_ucs2 0x0120),(_ucs2 0x0121),(_ucs2 0x0122),(_ucs2 0x0123);
110
insert into t1 values (_ucs2 0x0124),(_ucs2 0x0125),(_ucs2 0x0126),(_ucs2 0x0127);
111
insert into t1 values (_ucs2 0x0128),(_ucs2 0x0129),(_ucs2 0x012a),(_ucs2 0x012b);
112
insert into t1 values (_ucs2 0x012c),(_ucs2 0x012d),(_ucs2 0x012e),(_ucs2 0x012f);
113
insert into t1 values (_ucs2 0x0130),(_ucs2 0x0131),(_ucs2 0x0132),(_ucs2 0x0133);
114
insert into t1 values (_ucs2 0x0134),(_ucs2 0x0135),(_ucs2 0x0136),(_ucs2 0x0137);
115
insert into t1 values (_ucs2 0x0138),(_ucs2 0x0139),(_ucs2 0x013a),(_ucs2 0x013b);
116
insert into t1 values (_ucs2 0x013c),(_ucs2 0x013d),(_ucs2 0x013e),(_ucs2 0x013f);
117
insert into t1 values (_ucs2 0x0140),(_ucs2 0x0141),(_ucs2 0x0142),(_ucs2 0x0143);
118
insert into t1 values (_ucs2 0x0144),(_ucs2 0x0145),(_ucs2 0x0146),(_ucs2 0x0147);
119
insert into t1 values (_ucs2 0x0148),(_ucs2 0x0149),(_ucs2 0x014a),(_ucs2 0x014b);
120
insert into t1 values (_ucs2 0x014c),(_ucs2 0x014d),(_ucs2 0x014e),(_ucs2 0x014f);
121
insert into t1 values (_ucs2 0x0150),(_ucs2 0x0151),(_ucs2 0x0152),(_ucs2 0x0153);
122
insert into t1 values (_ucs2 0x0154),(_ucs2 0x0155),(_ucs2 0x0156),(_ucs2 0x0157);
123
insert into t1 values (_ucs2 0x0158),(_ucs2 0x0159),(_ucs2 0x015a),(_ucs2 0x015b);
124
insert into t1 values (_ucs2 0x015c),(_ucs2 0x015d),(_ucs2 0x015e),(_ucs2 0x015f);
125
insert into t1 values (_ucs2 0x0160),(_ucs2 0x0161),(_ucs2 0x0162),(_ucs2 0x0163);
126
insert into t1 values (_ucs2 0x0164),(_ucs2 0x0165),(_ucs2 0x0166),(_ucs2 0x0167);
127
insert into t1 values (_ucs2 0x0168),(_ucs2 0x0169),(_ucs2 0x016a),(_ucs2 0x016b);
128
insert into t1 values (_ucs2 0x016c),(_ucs2 0x016d),(_ucs2 0x016e),(_ucs2 0x016f);
129
insert into t1 values (_ucs2 0x0170),(_ucs2 0x0171),(_ucs2 0x0172),(_ucs2 0x0173);
130
insert into t1 values (_ucs2 0x0174),(_ucs2 0x0175),(_ucs2 0x0176),(_ucs2 0x0177);
131
insert into t1 values (_ucs2 0x0178),(_ucs2 0x0179),(_ucs2 0x017a),(_ucs2 0x017b);
132
insert into t1 values (_ucs2 0x017c),(_ucs2 0x017d),(_ucs2 0x017e),(_ucs2 0x017f);
133
insert into t1 values (_ucs2 0x0180),(_ucs2 0x0181),(_ucs2 0x0182),(_ucs2 0x0183);
134
insert into t1 values (_ucs2 0x0184),(_ucs2 0x0185),(_ucs2 0x0186),(_ucs2 0x0187);
135
insert into t1 values (_ucs2 0x0188),(_ucs2 0x0189),(_ucs2 0x018a),(_ucs2 0x018b);
136
insert into t1 values (_ucs2 0x018c),(_ucs2 0x018d),(_ucs2 0x018e),(_ucs2 0x018f);
137
insert into t1 values (_ucs2 0x0190),(_ucs2 0x0191),(_ucs2 0x0192),(_ucs2 0x0193);
138
insert into t1 values (_ucs2 0x0194),(_ucs2 0x0195),(_ucs2 0x0196),(_ucs2 0x0197);
139
insert into t1 values (_ucs2 0x0198),(_ucs2 0x0199),(_ucs2 0x019a),(_ucs2 0x019b);
140
insert into t1 values (_ucs2 0x019c),(_ucs2 0x019d),(_ucs2 0x019e),(_ucs2 0x019f);
141
insert into t1 values (_ucs2 0x01a0),(_ucs2 0x01a1),(_ucs2 0x01a2),(_ucs2 0x01a3);
142
insert into t1 values (_ucs2 0x01a4),(_ucs2 0x01a5),(_ucs2 0x01a6),(_ucs2 0x01a7);
143
insert into t1 values (_ucs2 0x01a8),(_ucs2 0x01a9),(_ucs2 0x01aa),(_ucs2 0x01ab);
144
insert into t1 values (_ucs2 0x01ac),(_ucs2 0x01ad),(_ucs2 0x01ae),(_ucs2 0x01af);
145
insert into t1 values (_ucs2 0x01b0),(_ucs2 0x01b1),(_ucs2 0x01b2),(_ucs2 0x01b3);
146
insert into t1 values (_ucs2 0x01b4),(_ucs2 0x01b5),(_ucs2 0x01b6),(_ucs2 0x01b7);
147
insert into t1 values (_ucs2 0x01b8),(_ucs2 0x01b9),(_ucs2 0x01ba),(_ucs2 0x01bb);
148
insert into t1 values (_ucs2 0x01bc),(_ucs2 0x01bd),(_ucs2 0x01be),(_ucs2 0x01bf);
149
insert into t1 values (_ucs2 0x01c0),(_ucs2 0x01c1),(_ucs2 0x01c2),(_ucs2 0x01c3);
150
insert into t1 values (_ucs2 0x01c4),(_ucs2 0x01c5),(_ucs2 0x01c6),(_ucs2 0x01c7);
151
insert into t1 values (_ucs2 0x01c8),(_ucs2 0x01c9),(_ucs2 0x01ca),(_ucs2 0x01cb);
152
insert into t1 values (_ucs2 0x01cc),(_ucs2 0x01cd),(_ucs2 0x01ce),(_ucs2 0x01cf);
153
insert into t1 values (_ucs2 0x01d0),(_ucs2 0x01d1),(_ucs2 0x01d2),(_ucs2 0x01d3);
154
insert into t1 values (_ucs2 0x01d4),(_ucs2 0x01d5),(_ucs2 0x01d6),(_ucs2 0x01d7);
155
insert into t1 values (_ucs2 0x01d8),(_ucs2 0x01d9),(_ucs2 0x01da),(_ucs2 0x01db);
156
insert into t1 values (_ucs2 0x01dc),(_ucs2 0x01dd),(_ucs2 0x01de),(_ucs2 0x01df);
157
insert into t1 values (_ucs2 0x01e0),(_ucs2 0x01e1),(_ucs2 0x01e2),(_ucs2 0x01e3);
158
insert into t1 values (_ucs2 0x01e4),(_ucs2 0x01e5),(_ucs2 0x01e6),(_ucs2 0x01e7);
159
insert into t1 values (_ucs2 0x01e8),(_ucs2 0x01e9),(_ucs2 0x01ea),(_ucs2 0x01eb);
160
insert into t1 values (_ucs2 0x01ec),(_ucs2 0x01ed),(_ucs2 0x01ee),(_ucs2 0x01ef);
161
insert into t1 values (_ucs2 0x01f0),(_ucs2 0x01f1),(_ucs2 0x01f2),(_ucs2 0x01f3);
162
insert into t1 values (_ucs2 0x01f4),(_ucs2 0x01f5),(_ucs2 0x01f6),(_ucs2 0x01f7);
163
insert into t1 values (_ucs2 0x01f8),(_ucs2 0x01f9),(_ucs2 0x01fa),(_ucs2 0x01fb);
164
insert into t1 values (_ucs2 0x01fc),(_ucs2 0x01fd),(_ucs2 0x01fe),(_ucs2 0x01ff);
165
insert into t1 values ('AA'),('Aa'),('aa'),('aA');
166
insert into t1 values ('CH'),('Ch'),('ch'),('cH');
167
insert into t1 values ('DZ'),('Dz'),('dz'),('dZ');
168
insert into t1 values ('IJ'),('Ij'),('ij'),('iJ');
169
insert into t1 values ('LJ'),('Lj'),('lj'),('lJ');
170
insert into t1 values ('LL'),('Ll'),('ll'),('lL');
171
insert into t1 values ('NJ'),('Nj'),('nj'),('nJ');
172
insert into t1 values ('OE'),('Oe'),('oe'),('oE');
173
insert into t1 values ('SS'),('Ss'),('ss'),('sS');
174
insert into t1 values ('RR'),('Rr'),('rr'),('rR');
175
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_unicode_ci;
176
group_concat(c1 order by binary c1 separator '')
179
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
210
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
231
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
253
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
279
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_icelandic_ci;
280
group_concat(c1 order by binary c1 separator '')
283
AaÀÂÃàâãĀāĂ㥹ǍǎǞǟǠǡǺǻ
338
OoÒÔÕòôõŌōŎŏŐőƠơǑǒǪǫǬǭ
361
UuÙÛÜùûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
392
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_latvian_ci;
393
group_concat(c1 order by binary c1 separator '')
396
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
429
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
454
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
478
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
505
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_romanian_ci;
506
group_concat(c1 order by binary c1 separator '')
509
AaÀÁÃÄÅàáãäåĀāĄąǍǎǞǟǠǡǺǻ
564
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
588
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
614
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_slovenian_ci;
615
group_concat(c1 order by binary c1 separator '')
618
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
650
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
671
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
694
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
721
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_polish_ci;
722
group_concat(c1 order by binary c1 separator '')
725
AaÀÁÂÃÄÅàáâãäåĀāĂăǍǎǞǟǠǡǺǻ
759
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
781
OoÒÔÕÖòôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
805
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
833
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_estonian_ci;
834
group_concat(c1 order by binary c1 separator '')
837
AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻ
869
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
890
OoÒÓÔòóôŌōŎŏŐőƠơǑǒǪǫǬǭ
915
UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
945
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_spanish_ci;
946
group_concat(c1 order by binary c1 separator '')
949
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
980
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1002
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1024
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1050
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_swedish_ci;
1051
group_concat(c1 order by binary c1 separator '')
1054
AaÀÁÂÃàáâãĀāĂ㥹ǍǎǞǟǠǡǺǻ
1071
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1085
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1106
OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭ
1128
UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1157
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_turkish_ci;
1158
group_concat(c1 order by binary c1 separator '')
1161
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1179
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1196
iÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1216
OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭ
1240
UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1267
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_czech_ci;
1268
group_concat(c1 order by binary c1 separator '')
1271
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1289
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1304
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1325
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1349
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1376
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_danish_ci;
1377
group_concat(c1 order by binary c1 separator '')
1380
AaÀÁÂÃàáâãĀāĂ㥹ǍǎǞǟǠǡǺǻ
1397
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1411
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1432
OoÒÓÔÕòóôõŌōŎŏƠơǑǒǪǫǬǭ
1454
UuÙÚÛùúûŨũŪūŬŭŮůŲųƯưǓǔǕǖǗǘǙǚǛǜ
1483
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_lithuanian_ci;
1484
group_concat(c1 order by binary c1 separator '')
1487
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1505
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1519
IYiyÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1540
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1563
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1590
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_slovak_ci;
1591
group_concat(c1 order by binary c1 separator '')
1594
AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1613
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1628
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1649
OoÒÓÕÖòóõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1673
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1700
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_spanish2_ci;
1701
group_concat(c1 order by binary c1 separator '')
1704
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1722
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1736
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1759
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1781
UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1807
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_roman_ci;
1808
group_concat(c1 order by binary c1 separator '')
1811
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1828
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1842
IJijÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1866
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1888
ÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
1914
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_esperanto_ci;
1915
group_concat(c1 order by binary c1 separator '')
1918
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
1936
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
1952
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
1974
OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭ
1997
UuÙÚÛÜùúûüŨũŪūŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜ
2024
select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_hungarian_ci;
2025
group_concat(c1 order by binary c1 separator '')
2028
AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻ
2045
EeÈÉÊËèéêëĒēĔĕĖėĘęĚě
2059
IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐ
2080
OoÒÓÔÕòóôõŌōŎŏƠơǑǒǪǫǬǭ
2103
UuÙÚÛùúûŨũŪūŬŭŮůŲųƯưǓǔǕǖǗǘǙǚǛǜ
2132
CREATE TABLE t1 (c varchar(200) CHARACTER SET utf32 COLLATE utf32_general_ci NOT NULL, INDEX (c));
2133
INSERT INTO t1 VALUES (_ucs2 0x039C03C903B403B11F770308);
2134
SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025 COLLATE utf32_general_ci;
2137
INSERT INTO t1 VALUES (CONVERT(_ucs2 0x039C03C903B4 USING utf8));
2138
SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025
2139
COLLATE utf32_general_ci ORDER BY c;
2144
CREATE TABLE t1 (c varchar(200) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL, INDEX (c));
2145
INSERT INTO t1 VALUES (_ucs2 0x039C03C903B403B11F770308);
2146
SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025 COLLATE utf32_unicode_ci;
2149
INSERT INTO t1 VALUES (_ucs2 0x039C03C903B4);
2150
SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025
2151
COLLATE utf32_unicode_ci ORDER BY c;
2156
CREATE TABLE t1 (c varchar(200) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL, INDEX (c));
2157
INSERT INTO t1 VALUES (_ucs2 0x039C03C903B403B11F770308);
2158
SELECT * FROM t1 WHERE c LIKE CONVERT(_ucs2 0x039C0025 USING utf32) COLLATE utf32_unicode_ci;
2161
INSERT INTO t1 VALUES (CONVERT(_ucs2 0x039C03C903B4 USING utf8));
2162
SELECT * FROM t1 WHERE c LIKE CONVERT(_ucs2 0x039C0025 USING utf32)
2163
COLLATE utf32_unicode_ci ORDER BY c;
2169
SET @test_character_set='utf32';
2170
SET @test_collation='utf32_swedish_ci';
2171
SET @safe_character_set_server= @@character_set_server;
2172
SET @safe_collation_server= @@collation_server;
2173
SET @safe_character_set_client= @@character_set_client;
2174
SET @safe_character_set_results= @@character_set_results;
2175
SET character_set_server= @test_character_set;
2176
SET collation_server= @test_collation;
2179
CREATE TABLE t1 (c CHAR(10), KEY(c));
2180
SHOW FULL COLUMNS FROM t1;
2181
Field Type Collation Null Key Default Extra Privileges Comment
2182
c char(10) utf32_swedish_ci YES MUL NULL
2183
INSERT INTO t1 VALUES ('aaa'),('aaaa'),('aaaaa');
2184
SELECT c as want3results FROM t1 WHERE c LIKE 'aaa%';
2190
CREATE TABLE t1 (c1 varchar(15), KEY c1 (c1(2)));
2191
SHOW FULL COLUMNS FROM t1;
2192
Field Type Collation Null Key Default Extra Privileges Comment
2193
c1 varchar(15) utf32_swedish_ci YES MUL NULL
2194
INSERT INTO t1 VALUES ('location'),('loberge'),('lotre'),('boabab');
2195
SELECT c1 as want3results from t1 where c1 like 'l%';
2200
SELECT c1 as want3results from t1 where c1 like 'lo%';
2205
SELECT c1 as want1result from t1 where c1 like 'loc%';
2208
SELECT c1 as want1result from t1 where c1 like 'loca%';
2211
SELECT c1 as want1result from t1 where c1 like 'locat%';
2214
SELECT c1 as want1result from t1 where c1 like 'locati%';
2217
SELECT c1 as want1result from t1 where c1 like 'locatio%';
2220
SELECT c1 as want1result from t1 where c1 like 'location%';
2224
create table t1 (a set('a') not null);
2225
insert into t1 values (),();
2227
Warning 1364 Field 'a' doesn't have a default value
2228
select cast(a as char(1)) from t1;
2232
select a sounds like a from t1;
2236
select 1 from t1 order by cast(a as char(1));
2244
level smallint unsigned);
2245
show create table t1;
2247
t1 CREATE TABLE `t1` (
2248
`name` varchar(10) COLLATE utf32_swedish_ci DEFAULT NULL,
2249
`level` smallint(5) unsigned DEFAULT NULL
2250
) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_swedish_ci
2251
insert into t1 values ('string',1);
2252
select concat(name,space(level)), concat(name, repeat(' ',level)) from t1;
2253
concat(name,space(level)) concat(name, repeat(' ',level))
2258
SET character_set_server= @safe_character_set_server;
2259
SET collation_server= @safe_collation_server;
2260
SET character_set_client= @safe_character_set_client;
2261
SET character_set_results= @safe_character_set_results;
2262
SET collation_connection='utf32_unicode_ci';
2263
create table t1 select repeat('a',4000) a;
2265
insert into t1 values ('a'), ('a '), ('a\t');
2266
select collation(a),hex(a) from t1 order by a;
2268
utf32_unicode_ci 0000006100000009
2269
utf32_unicode_ci 00000061
2270
utf32_unicode_ci 0000006100000020
2272
select @@collation_connection;
2273
@@collation_connection
2275
create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ;
2276
insert into t1 values('abcdef');
2277
insert into t1 values('_bcdef');
2278
insert into t1 values('a_cdef');
2279
insert into t1 values('ab_def');
2280
insert into t1 values('abc_ef');
2281
insert into t1 values('abcd_f');
2282
insert into t1 values('abcde_');
2283
select c1 as c1u from t1 where c1 like 'ab\_def';
2286
select c1 as c2h from t1 where c1 like 'ab#_def' escape '#';
2291
CREATE TABLE t1 (id int, a varchar(30) character set utf32);
2292
INSERT INTO t1 VALUES (1, _ucs2 0x01310069), (2, _ucs2 0x01310131);
2293
INSERT INTO t1 VALUES (3, _ucs2 0x00690069), (4, _ucs2 0x01300049);
2294
INSERT INTO t1 VALUES (5, _ucs2 0x01300130), (6, _ucs2 0x00490049);
2295
SELECT a, length(a) la, @l:=lower(a) l, length(@l) ll, @u:=upper(a) u, length(@u) lu
2296
FROM t1 ORDER BY id;
2304
ALTER TABLE t1 MODIFY a VARCHAR(30) character set utf32 collate utf32_turkish_ci;
2305
SELECT a, length(a) la, @l:=lower(a) l, length(@l) ll, @u:=upper(a) u, length(@u) lu
2306
FROM t1 ORDER BY id;
2316
c1 text character set utf32 collate utf32_polish_ci NOT NULL
2318
insert into t1 values (''),('a');
2319
SELECT COUNT(*), c1 FROM t1 GROUP BY c1;
2323
DROP TABLE IF EXISTS t1;
2325
set collation_connection=utf32_unicode_ci;
2326
select @@collation_connection;
2327
@@collation_connection
2329
select hex(weight_string('a'));
2330
hex(weight_string('a'))
2332
select hex(weight_string('A'));
2333
hex(weight_string('A'))
2335
select hex(weight_string('abc'));
2336
hex(weight_string('abc'))
2338
select hex(weight_string('abc' as char(2)));
2339
hex(weight_string('abc' as char(2)))
2341
select hex(weight_string('abc' as char(3)));
2342
hex(weight_string('abc' as char(3)))
2344
select hex(weight_string('abc' as char(5)));
2345
hex(weight_string('abc' as char(5)))
2346
0E330E4A0E6002090209
2347
select hex(weight_string(_utf32 0x10000 collate utf32_unicode_ci));
2348
hex(weight_string(_utf32 0x10000 collate utf32_unicode_ci))
2350
select hex(weight_string(_utf32 0x10001 collate utf32_unicode_ci));
2351
hex(weight_string(_utf32 0x10001 collate utf32_unicode_ci))
2353
select @@collation_connection;
2354
@@collation_connection
2356
select hex(weight_string('a' LEVEL 1));
2357
hex(weight_string('a' LEVEL 1))
2359
select hex(weight_string('A' LEVEL 1));
2360
hex(weight_string('A' LEVEL 1))
2362
select hex(weight_string('abc' LEVEL 1));
2363
hex(weight_string('abc' LEVEL 1))
2365
select hex(weight_string('abc' as char(2) LEVEL 1));
2366
hex(weight_string('abc' as char(2) LEVEL 1))
2368
select hex(weight_string('abc' as char(3) LEVEL 1));
2369
hex(weight_string('abc' as char(3) LEVEL 1))
2371
select hex(weight_string('abc' as char(5) LEVEL 1));
2372
hex(weight_string('abc' as char(5) LEVEL 1))
2373
0E330E4A0E6002090209
2374
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
2375
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
2376
09020902600E4A0E330E
2377
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
2378
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
2379
F1CCF1B5F19FFDF6FDF6
2380
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
2381
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))
2382
F6FDF6FD9FF1B5F1CCF1
2383
set @@collation_connection=utf32_czech_ci;
2384
select @@collation_connection;
2385
@@collation_connection
2387
select collation(cast(_latin1 0xDF as char));
2388
collation(cast(_latin1 0xDF as char))
2390
select hex(weight_string('s'));
2391
hex(weight_string('s'))
2393
select hex(weight_string(cast(_latin1 0xDF as char)));
2394
hex(weight_string(cast(_latin1 0xDF as char)))
2396
select hex(weight_string(cast(_latin1 0xDF as char) as char(1)));
2397
hex(weight_string(cast(_latin1 0xDF as char) as char(1)))
2399
select hex(weight_string('c'));
2400
hex(weight_string('c'))
2402
select hex(weight_string('h'));
2403
hex(weight_string('h'))
2405
select hex(weight_string('ch'));
2406
hex(weight_string('ch'))
2408
select hex(weight_string('i'));
2409
hex(weight_string('i'))
2411
select hex(weight_string(cast(_latin1 0x6368DF as char)));
2412
hex(weight_string(cast(_latin1 0x6368DF as char)))
2414
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(1)));
2415
hex(weight_string(cast(_latin1 0x6368DF as char) as char(1)))
2417
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(2)));
2418
hex(weight_string(cast(_latin1 0x6368DF as char) as char(2)))
2420
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(3)));
2421
hex(weight_string(cast(_latin1 0x6368DF as char) as char(3)))
2423
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(4)));
2424
hex(weight_string(cast(_latin1 0x6368DF as char) as char(4)))
2426
select hex(weight_string(cast(_latin1 0xDF6368 as char)));
2427
hex(weight_string(cast(_latin1 0xDF6368 as char)))
2429
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1)));
2430
hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1)))
2432
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2)));
2433
hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2)))
2435
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3)));
2436
hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3)))
2438
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4)));
2439
hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4)))
2441
set collation_connection=utf32_unicode_ci;
2442
drop table if exists t1;
2444
select repeat(' ', 64) as s1, repeat(' ',64) as s2
2447
show create table t1;
2449
t1 CREATE TABLE `t1` (
2450
`s1` varchar(64) CHARACTER SET utf32 COLLATE utf32_unicode_ci DEFAULT NULL,
2451
`s2` varchar(64) CHARACTER SET utf32 COLLATE utf32_unicode_ci DEFAULT NULL
2452
) ENGINE=MyISAM DEFAULT CHARSET=latin1
2454
insert into t1 values('aaa','aaa');
2455
insert into t1 values('aaa|qqq','qqq');
2456
insert into t1 values('gheis','^[^a-dXYZ]+$');
2457
insert into t1 values('aab','^aa?b');
2458
insert into t1 values('Baaan','^Ba*n');
2459
insert into t1 values('aaa','qqq|aaa');
2460
insert into t1 values('qqq','qqq|aaa');
2461
insert into t1 values('bbb','qqq|aaa');
2462
insert into t1 values('bbb','qqq');
2463
insert into t1 values('aaa','aba');
2464
insert into t1 values(null,'abc');
2465
insert into t1 values('def',null);
2466
insert into t1 values(null,null);
2467
insert into t1 values('ghi','ghi[');
2468
select HIGH_PRIORITY s1 regexp s2 from t1;