2
a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2))
3
) character set utf8 engine = MyISAM;
5
a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2))
6
) character set ucs2 engine = MyISAM;
7
insert into t1 values (1,'abcdefg','abcdefg','one');
8
insert into t1 values (2,'ijkilmn','ijkilmn','two');
9
insert into t1 values (3,'qrstuvw','qrstuvw','three');
10
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
11
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
12
insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six');
13
insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven');
14
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
15
insert into t2 values (1,'abcdefg','abcdefg','one');
16
insert into t2 values (2,'ijkilmn','ijkilmn','two');
17
insert into t2 values (3,'qrstuvw','qrstuvw','three');
18
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
19
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
20
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
21
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
22
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
23
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
24
insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven');
25
insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point');
26
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
27
update t1 set filler = 'boo' where a = 1;
28
update t2 set filler ='email' where a = 4;
29
select a,hex(b),hex(c),filler from t1 order by filler;
30
a hex(b) hex(c) filler
31
1 61626364656667 61626364656667 boo
35
4 E880BDD0B1E880BD E880BDD0B1E880BD seven
36
4 E880BDE880BD E880BDE880BD six
37
3 71727374757677 71727374757677 three
38
2 696A6B696C6D6E 696A6B696C6D6E two
39
select a,hex(b),hex(c),filler from t2 order by filler;
40
a hex(b) hex(c) filler
41
4 05612020 05612020 email
42
4 0000563001FC0563 0000563001FC0563 email
43
4 05630563 05630563 email
47
4 00E400E50068 00E400E50068 email
48
4 00640065 00640065 email
49
4 0000E400 0000E400 email
50
1 0061006200630064006500660067 0061006200630064006500660067 one
51
3 0071007200730074007500760077 0071007200730074007500760077 three
52
2 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E two
56
a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2))
57
) character set utf8 engine = MyISAM;
59
a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2))
60
) character set ucs2 engine = MyISAM;
61
insert into t1 values (1,'abcdefg','abcdefg','one');
62
insert into t1 values (2,'ijkilmn','ijkilmn','two');
63
insert into t1 values (3,'qrstuvw','qrstuvw','three');
64
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
65
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
66
insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six');
67
insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven');
68
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
69
insert into t2 values (1,'abcdefg','abcdefg','one');
70
insert into t2 values (2,'ijkilmn','ijkilmn','two');
71
insert into t2 values (3,'qrstuvw','qrstuvw','three');
72
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
73
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
74
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
75
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
76
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
77
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
78
insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven');
79
insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point');
80
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
81
update t1 set filler = 'boo' where a = 1;
82
update t2 set filler ='email' where a = 4;
83
select a,hex(b),hex(c),filler from t1 order by filler;
84
a hex(b) hex(c) filler
85
1 61626364656667 61626364656667 boo
89
4 E880BDD0B1E880BD E880BDD0B1E880BD seven
90
4 E880BDE880BD E880BDE880BD six
91
3 71727374757677 71727374757677 three
92
2 696A6B696C6D6E 696A6B696C6D6E two
93
select a,hex(b),hex(c),filler from t2 order by filler;
94
a hex(b) hex(c) filler
95
4 05612020 05612020 email
96
4 0000563001FC0563 0000563001FC0563 email
97
4 05630563 05630563 email
101
4 00E400E50068 00E400E50068 email
102
4 00640065 00640065 email
103
4 0000E400 0000E400 email
104
1 0061006200630064006500660067 0061006200630064006500660067 one
105
3 0071007200730074007500760077 0071007200730074007500760077 three
106
2 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E two
110
a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2))
111
) character set utf8 engine = MyISAM;
113
a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2))
114
) character set ucs2 engine = MyISAM;
115
insert into t1 values (1,'abcdefg','abcdefg','one');
116
insert into t1 values (2,'ijkilmn','ijkilmn','two');
117
insert into t1 values (3,'qrstuvw','qrstuvw','three');
118
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
119
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
120
insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six');
121
insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven');
122
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
123
insert into t2 values (1,'abcdefg','abcdefg','one');
124
insert into t2 values (2,'ijkilmn','ijkilmn','two');
125
insert into t2 values (3,'qrstuvw','qrstuvw','three');
126
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
127
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
128
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
129
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
130
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
131
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
132
insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven');
133
insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point');
134
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
135
update t1 set filler = 'boo' where a = 1;
136
update t2 set filler ='email' where a = 4;
137
select a,hex(b),hex(c),filler from t1 order by filler;
138
a hex(b) hex(c) filler
139
1 61626364656667 61626364656667 boo
143
4 E880BDD0B1E880BD E880BDD0B1E880BD seven
144
4 E880BDE880BD E880BDE880BD six
145
3 71727374757677 71727374757677 three
146
2 696A6B696C6D6E 696A6B696C6D6E two
147
select a,hex(b),hex(c),filler from t2 order by filler;
148
a hex(b) hex(c) filler
149
4 0000E400 0000E400 email
150
4 00640065 00640065 email
151
4 00E400E50068 00E400E50068 email
155
4 05630563 05630563 email
156
4 0000563001FC0563 0000563001FC0563 email
157
4 05612020 05612020 email
158
1 0061006200630064006500660067 0061006200630064006500660067 one
159
3 0071007200730074007500760077 0071007200730074007500760077 three
160
2 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E two
164
a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2))
165
) character set utf8 engine = MyISAM;
167
a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2))
168
) character set ucs2 engine = MyISAM;
169
insert into t1 values (1,'abcdefg','abcdefg','one');
170
insert into t1 values (2,'ijkilmn','ijkilmn','two');
171
insert into t1 values (3,'qrstuvw','qrstuvw','three');
172
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
173
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
174
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
175
insert into t2 values (1,'abcdefg','abcdefg','one');
176
insert into t2 values (2,'ijkilmn','ijkilmn','two');
177
insert into t2 values (3,'qrstuvw','qrstuvw','three');
178
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
179
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
180
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
181
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
182
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
183
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
184
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
185
update t1 set filler = 'boo' where a = 1;
186
update t2 set filler ='email' where a = 4;
187
select a,hex(b),hex(c),filler from t1 order by filler;
188
a hex(b) hex(c) filler
189
1 61626364656667 61626364656667 boo
193
3 71727374757677 71727374757677 three
194
2 696A6B696C6D6E 696A6B696C6D6E two
195
select a,hex(b),hex(c),filler from t2 order by filler;
196
a hex(b) hex(c) filler
197
4 0000E400 0000E400 email
198
4 00640065 00640065 email
199
4 00E400E50068 00E400E50068 email
203
4 05612020 05612020 email
204
1 61626364656667 61626364656667 one
205
3 71727374757677 71727374757677 three
206
2 696A6B696C6D6E 696A6B696C6D6E two
211
ind enum('0','1','2') NOT NULL default '0',
212
string1 varchar(250) NOT NULL,
214
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
216
ind enum('0','1','2') NOT NULL default '0',
217
string1 varchar(250) NOT NULL,
219
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
220
INSERT INTO t1 VALUES ('1', ''),('2', '');
221
INSERT INTO t2 VALUES ('1', ''),('2', '');
222
SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1;
223
hex(ind) hex(string1)
226
SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1;
227
hex(ind) hex(string1)
232
ind set('0','1','2') NOT NULL default '0',
233
string1 varchar(250) NOT NULL,
235
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
237
ind set('0','1','2') NOT NULL default '0',
238
string1 varchar(250) NOT NULL,
240
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
241
INSERT INTO t1 VALUES ('1', ''),('2', '');
242
INSERT INTO t2 VALUES ('1', ''),('2', '');
243
SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1;
244
hex(ind) hex(string1)
247
SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1;
248
hex(ind) hex(string1)
254
string1 varchar(250) NOT NULL,
256
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
259
string1 varchar(250) NOT NULL,
261
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
262
insert into t1 values(0,''),(1,'');
263
insert into t2 values(0,''),(1,'');
264
select hex(ind),hex(string1) from t1 order by string1;
265
hex(ind) hex(string1)
268
select hex(ind),hex(string1) from t2 order by string1;
269
hex(ind) hex(string1)
274
a int, b char(10), filler char(10), primary key(a, b(2))
275
) character set utf8 engine = MyISAM;
276
insert into t2 values (1,'abcdefg','one');
277
insert into t2 values (2,'ijkilmn','two');
278
insert into t2 values (3, 'qrstuvw','three');
279
update t2 set a=5, filler='booo' where a=1;
282
a int, b char(10), filler char(10), primary key(a, b(2))
283
) character set ucs2 engine = MyISAM;
284
insert into t2 values (1,'abcdefg','one');
285
insert into t2 values (2,'ijkilmn','two');
286
insert into t2 values (3, 'qrstuvw','three');
287
update t2 set a=5, filler='booo' where a=1;
289
create table t1(a int not null, b char(110),primary key(a,b(100))) engine=MyISAM default charset=utf8;
290
insert into t1 values(1,'abcdefg'),(2,'defghijk');
291
insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1);
292
insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2);
293
select a,hex(b) from t1 order by b;
297
6 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1
298
7 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2
299
update t1 set b = 'three' where a = 6;
301
create table t1(a int not null, b text(110),primary key(a,b(100))) engine=MyISAM default charset=utf8;
302
insert into t1 values(1,'abcdefg'),(2,'defghijk');
303
insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1);
304
insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2);
305
select a,hex(b) from t1 order by b;
309
6 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1
310
7 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2
311
update t1 set b = 'three' where a = 6;