�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain%2F'>main</a>/</p><hr><h3>✏️ Editing: mix2_myisam_ucs2.result</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>create table t1 (
a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2))
) character set utf8 engine = MyISAM;
create table t2 (
a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2))
) character set ucs2 engine = MyISAM;
insert into t1 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t1 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t1 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,&#039;four&#039;);
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,&#039;five&#039;);
insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,&#039;six&#039;);
insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,&#039;seven&#039;);
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,&#039;eight&#039;);
insert into t2 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t2 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t2 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,&#039;four&#039;);
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,&#039;five&#039;);
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,&#039;six&#039;);
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,&#039;seven&#039;);
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,&#039;eight&#039;);
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,&#039;ten&#039;);
insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,&#039;eleven&#039;);
insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,&#039;point&#039;);
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,&#039;taken&#039;);
update t1 set filler = &#039;boo&#039; where a = 1;
update t2 set filler =&#039;email&#039; where a = 4;
select a,hex(b),hex(c),filler from t1 order by filler;
a	hex(b)	hex(c)	filler
1	61626364656667	61626364656667	boo
4	D0B1	D0B1	eight
4	5B	5B	five
4	E880BD	E880BD	four
4	E880BDD0B1E880BD	E880BDD0B1E880BD	seven
4	E880BDE880BD	E880BDE880BD	six
3	71727374757677	71727374757677	three
2	696A6B696C6D6E	696A6B696C6D6E	two
select a,hex(b),hex(c),filler from t2 order by filler;
a	hex(b)	hex(c)	filler
4	05612020	05612020	email
4	0000563001FC0563	0000563001FC0563	email
4	05630563	05630563	email
4	0563	0563	email
4	0120	0120	email
4	01FC	01FC	email
4	00E400E50068	00E400E50068	email
4	00640065	00640065	email
4	0000E400	0000E400	email
1	0061006200630064006500660067	0061006200630064006500660067	one
3	0071007200730074007500760077	0071007200730074007500760077	three
2	0069006A006B0069006C006D006E	0069006A006B0069006C006D006E	two
drop table t1;
drop table t2;
create table t1 (
a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2))
) character set utf8 engine = MyISAM;
create table t2 (
a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2))
) character set ucs2 engine = MyISAM;
insert into t1 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t1 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t1 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,&#039;four&#039;);
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,&#039;five&#039;);
insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,&#039;six&#039;);
insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,&#039;seven&#039;);
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,&#039;eight&#039;);
insert into t2 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t2 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t2 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,&#039;four&#039;);
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,&#039;five&#039;);
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,&#039;six&#039;);
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,&#039;seven&#039;);
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,&#039;eight&#039;);
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,&#039;ten&#039;);
insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,&#039;eleven&#039;);
insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,&#039;point&#039;);
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,&#039;taken&#039;);
update t1 set filler = &#039;boo&#039; where a = 1;
update t2 set filler =&#039;email&#039; where a = 4;
select a,hex(b),hex(c),filler from t1 order by filler;
a	hex(b)	hex(c)	filler
1	61626364656667	61626364656667	boo
4	D0B1	D0B1	eight
4	5B	5B	five
4	E880BD	E880BD	four
4	E880BDD0B1E880BD	E880BDD0B1E880BD	seven
4	E880BDE880BD	E880BDE880BD	six
3	71727374757677	71727374757677	three
2	696A6B696C6D6E	696A6B696C6D6E	two
select a,hex(b),hex(c),filler from t2 order by filler;
a	hex(b)	hex(c)	filler
4	05612020	05612020	email
4	0000563001FC0563	0000563001FC0563	email
4	05630563	05630563	email
4	0563	0563	email
4	0120	0120	email
4	01FC	01FC	email
4	00E400E50068	00E400E50068	email
4	00640065	00640065	email
4	0000E400	0000E400	email
1	0061006200630064006500660067	0061006200630064006500660067	one
3	0071007200730074007500760077	0071007200730074007500760077	three
2	0069006A006B0069006C006D006E	0069006A006B0069006C006D006E	two
drop table t1;
drop table t2;
create table t1 (
a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2))
) character set utf8 engine = MyISAM;
create table t2 (
a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2))
) character set ucs2 engine = MyISAM;
insert into t1 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t1 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t1 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,&#039;four&#039;);
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,&#039;five&#039;);
insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,&#039;six&#039;);
insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,&#039;seven&#039;);
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,&#039;eight&#039;);
insert into t2 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t2 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t2 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,&#039;four&#039;);
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,&#039;five&#039;);
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,&#039;six&#039;);
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,&#039;seven&#039;);
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,&#039;eight&#039;);
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,&#039;ten&#039;);
insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,&#039;eleven&#039;);
insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,&#039;point&#039;);
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,&#039;taken&#039;);
update t1 set filler = &#039;boo&#039; where a = 1;
update t2 set filler =&#039;email&#039; where a = 4;
select a,hex(b),hex(c),filler from t1 order by filler;
a	hex(b)	hex(c)	filler
1	61626364656667	61626364656667	boo
4	D0B1	D0B1	eight
4	5B	5B	five
4	E880BD	E880BD	four
4	E880BDD0B1E880BD	E880BDD0B1E880BD	seven
4	E880BDE880BD	E880BDE880BD	six
3	71727374757677	71727374757677	three
2	696A6B696C6D6E	696A6B696C6D6E	two
select a,hex(b),hex(c),filler from t2 order by filler;
a	hex(b)	hex(c)	filler
4	0000E400	0000E400	email
4	00640065	00640065	email
4	00E400E50068	00E400E50068	email
4	01FC	01FC	email
4	0120	0120	email
4	0563	0563	email
4	05630563	05630563	email
4	0000563001FC0563	0000563001FC0563	email
4	05612020	05612020	email
1	0061006200630064006500660067	0061006200630064006500660067	one
3	0071007200730074007500760077	0071007200730074007500760077	three
2	0069006A006B0069006C006D006E	0069006A006B0069006C006D006E	two
drop table t1;
drop table t2;
create table t1 (
a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2))
) character set utf8 engine = MyISAM;
create table t2 (
a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2))
) character set ucs2 engine = MyISAM;
insert into t1 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t1 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t1 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,&#039;four&#039;);
insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,&#039;five&#039;);
insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,&#039;eight&#039;);
insert into t2 values (1,&#039;abcdefg&#039;,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t2 values (2,&#039;ijkilmn&#039;,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t2 values (3,&#039;qrstuvw&#039;,&#039;qrstuvw&#039;,&#039;three&#039;);
insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,&#039;four&#039;);
insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,&#039;five&#039;);
insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,&#039;six&#039;);
insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,&#039;seven&#039;);
insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,&#039;eight&#039;);
insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,&#039;ten&#039;);
insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,&#039;taken&#039;);
update t1 set filler = &#039;boo&#039; where a = 1;
update t2 set filler =&#039;email&#039; where a = 4;
select a,hex(b),hex(c),filler from t1 order by filler;
a	hex(b)	hex(c)	filler
1	61626364656667	61626364656667	boo
4	D0B1	D0B1	eight
4	5B	5B	five
4	E880BD	E880BD	four
3	71727374757677	71727374757677	three
2	696A6B696C6D6E	696A6B696C6D6E	two
select a,hex(b),hex(c),filler from t2 order by filler;
a	hex(b)	hex(c)	filler
4	0000E400	0000E400	email
4	00640065	00640065	email
4	00E400E50068	00E400E50068	email
4	01FC	01FC	email
4	0120	0120	email
4	0563	0563	email
4	05612020	05612020	email
1	61626364656667	61626364656667	one
3	71727374757677	71727374757677	three
2	696A6B696C6D6E	696A6B696C6D6E	two
drop table t1;
drop table t2;
commit;
CREATE TABLE t1 (
ind enum(&#039;0&#039;,&#039;1&#039;,&#039;2&#039;) NOT NULL default &#039;0&#039;,
string1 varchar(250) NOT NULL,
PRIMARY KEY  (ind)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE t2 (
ind enum(&#039;0&#039;,&#039;1&#039;,&#039;2&#039;) NOT NULL default &#039;0&#039;,
string1 varchar(250) NOT NULL,
PRIMARY KEY  (ind)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
INSERT INTO t1 VALUES (&#039;1&#039;, &#039;&#039;),(&#039;2&#039;, &#039;&#039;);
INSERT INTO t2 VALUES (&#039;1&#039;, &#039;&#039;),(&#039;2&#039;, &#039;&#039;);
SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1;
hex(ind)	hex(string1)
31	
32	
SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1;
hex(ind)	hex(string1)
0031	
0032	
drop table t1,t2;
CREATE TABLE t1 (
ind set(&#039;0&#039;,&#039;1&#039;,&#039;2&#039;) NOT NULL default &#039;0&#039;,
string1 varchar(250) NOT NULL,
PRIMARY KEY  (ind)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE t2 (
ind set(&#039;0&#039;,&#039;1&#039;,&#039;2&#039;) NOT NULL default &#039;0&#039;,
string1 varchar(250) NOT NULL,
PRIMARY KEY  (ind)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
INSERT INTO t1 VALUES (&#039;1&#039;, &#039;&#039;),(&#039;2&#039;, &#039;&#039;);
INSERT INTO t2 VALUES (&#039;1&#039;, &#039;&#039;),(&#039;2&#039;, &#039;&#039;);
SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1;
hex(ind)	hex(string1)
31	
32	
SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1;
hex(ind)	hex(string1)
0031	
0032	
drop table t1,t2;
CREATE TABLE t1 (
ind bit not null,
string1 varchar(250) NOT NULL,
PRIMARY KEY  (ind)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE t2 (
ind bit not null,
string1 varchar(250) NOT NULL,
PRIMARY KEY  (ind)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2;
insert into t1 values(0,&#039;&#039;),(1,&#039;&#039;);
insert into t2 values(0,&#039;&#039;),(1,&#039;&#039;);
select hex(ind),hex(string1) from t1 order by string1;
hex(ind)	hex(string1)
0	
1	
select hex(ind),hex(string1) from t2 order by string1;
hex(ind)	hex(string1)
0	
1	
drop table t1,t2;
create table t2 (
a int, b char(10), filler char(10), primary key(a, b(2))
) character set utf8 engine = MyISAM;
insert into t2 values (1,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t2 values (2,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t2 values (3, &#039;qrstuvw&#039;,&#039;three&#039;);
update t2 set a=5, filler=&#039;booo&#039; where a=1;
drop table t2;
create table t2 (
a int, b char(10), filler char(10), primary key(a, b(2))
) character set ucs2 engine = MyISAM;
insert into t2 values (1,&#039;abcdefg&#039;,&#039;one&#039;);
insert into t2 values (2,&#039;ijkilmn&#039;,&#039;two&#039;);
insert into t2 values (3, &#039;qrstuvw&#039;,&#039;three&#039;);
update t2 set a=5, filler=&#039;booo&#039; where a=1;
drop table t2;
create table t1(a int not null, b char(110),primary key(a,b(100))) engine=MyISAM default charset=utf8;
insert into t1 values(1,&#039;abcdefg&#039;),(2,&#039;defghijk&#039;);
insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1);
insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2);
select a,hex(b) from t1 order by b;
a	hex(b)
1	61626364656667
2	6465666768696A6B
6	D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1
7	D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2
update t1 set b = &#039;three&#039; where a = 6;
drop table t1;
create table t1(a int not null, b text(110),primary key(a,b(100))) engine=MyISAM default charset=utf8;
insert into t1 values(1,&#039;abcdefg&#039;),(2,&#039;defghijk&#039;);
insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1);
insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2);
select a,hex(b) from t1 order by b;
a	hex(b)
1	61626364656667
2	6465666768696A6B
6	D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1
7	D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2
update t1 set b = &#039;three&#039; where a = 6;
drop table t1;
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain'>🔙 Back</a></p>