drop table if exists t1, t2; 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 = innodb; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 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 = innodb; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t1 values (1,'abcdefg','abcdefg','one'); insert into t1 values (2,'ijkilmn','ijkilmn','two'); insert into t1 values (3,'qrstuvw','qrstuvw','three'); insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t2 values (1,'abcdefg','abcdefg','one'); insert into t2 values (2,'ijkilmn','ijkilmn','two'); insert into t2 values (3,'qrstuvw','qrstuvw','three'); insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead update t1 set filler = 'boo' where a = 1; update t2 set filler ='email' where a = 4; select filler,a,hex(b),hex(c) from t1 order by filler; filler a hex(b) hex(c) boo 1 61626364656667 61626364656667 eight 4 D0B1 D0B1 five 4 5B 5B four 4 E880BD E880BD seven 4 E880BDD0B1E880BD E880BDD0B1E880BD six 4 E880BDE880BD E880BDE880BD three 3 71727374757677 71727374757677 two 2 696A6B696C6D6E 696A6B696C6D6E select filler,hex(b),a,hex(c) from t2 order by filler, hex(b) desc; filler hex(b) a hex(c) email 05630563 4 05630563 email 05612020 4 05612020 email 0563 4 0563 email 01FC 4 01FC email 0120 4 0120 email 00E400E50068 4 00E400E50068 email 00640065 4 00640065 email 0000E400 4 0000E400 email 0000563001FC0563 4 0000563001FC0563 one 0061006200630064006500660067 1 0061006200630064006500660067 three 0071007200730074007500760077 3 0071007200730074007500760077 two 0069006A006B0069006C006D006E 2 0069006A006B0069006C006D006E 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 = innodb; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 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 = innodb; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t1 values (1,'abcdefg','abcdefg','one'); insert into t1 values (2,'ijkilmn','ijkilmn','two'); insert into t1 values (3,'qrstuvw','qrstuvw','three'); insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t2 values (1,'abcdefg','abcdefg','one'); insert into t2 values (2,'ijkilmn','ijkilmn','two'); insert into t2 values (3,'qrstuvw','qrstuvw','three'); insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead update t1 set filler = 'boo' where a = 1; update t2 set filler ='email' where a = 4; select filler,a,hex(b),hex(c) from t1 order by filler; filler a hex(b) hex(c) boo 1 61626364656667 61626364656667 eight 4 D0B1 D0B1 five 4 5B 5B four 4 E880BD E880BD seven 4 E880BDD0B1E880BD E880BDD0B1E880BD six 4 E880BDE880BD E880BDE880BD three 3 71727374757677 71727374757677 two 2 696A6B696C6D6E 696A6B696C6D6E select filler,hex(b),a,hex(c) from t2 order by filler, hex(b) desc; filler hex(b) a hex(c) email 05630563 4 05630563 email 05612020 4 05612020 email 0563 4 0563 email 01FC 4 01FC email 0120 4 0120 email 00E400E50068 4 00E400E50068 email 00640065 4 00640065 email 0000E400 4 0000E400 email 0000563001FC0563 4 0000563001FC0563 one 0061006200630064006500660067 1 0061006200630064006500660067 three 0071007200730074007500760077 3 0071007200730074007500760077 two 0069006A006B0069006C006D006E 2 0069006A006B0069006C006D006E 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 = innodb; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 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 = innodb; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t1 values (1,'abcdefg','abcdefg','one'); insert into t1 values (2,'ijkilmn','ijkilmn','two'); insert into t1 values (3,'qrstuvw','qrstuvw','three'); insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t2 values (1,'abcdefg','abcdefg','one'); insert into t2 values (2,'ijkilmn','ijkilmn','two'); insert into t2 values (3,'qrstuvw','qrstuvw','three'); insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead update t1 set filler = 'boo' where a = 1; update t2 set filler ='email' where a = 4; select filler,a,hex(b),hex(c) from t1 order by filler; filler a hex(b) hex(c) boo 1 61626364656667 61626364656667 eight 4 D0B1 D0B1 five 4 5B 5B four 4 E880BD E880BD seven 4 E880BDD0B1E880BD E880BDD0B1E880BD six 4 E880BDE880BD E880BDE880BD three 3 71727374757677 71727374757677 two 2 696A6B696C6D6E 696A6B696C6D6E select filler,a,hex(b),hex(c) from t2 order by filler; filler a hex(b) hex(c) email 4 0000563001FC0563 0000563001FC0563 email 4 0000E400 0000E400 email 4 00640065 00640065 email 4 00E400E50068 00E400E50068 email 4 0120 0120 email 4 01FC 01FC email 4 05612020 05612020 email 4 0563 0563 email 4 05630563 05630563 one 1 0061006200630064006500660067 0061006200630064006500660067 three 3 0071007200730074007500760077 0071007200730074007500760077 two 2 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E 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 = innodb; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 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 = innodb; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t1 values (1,'abcdefg','abcdefg','one'); insert into t1 values (2,'ijkilmn','ijkilmn','two'); insert into t1 values (3,'qrstuvw','qrstuvw','three'); insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t2 values (1,'abcdefg','abcdefg','one'); insert into t2 values (2,'ijkilmn','ijkilmn','two'); insert into t2 values (3,'qrstuvw','qrstuvw','three'); insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead update t1 set filler = 'boo' where a = 1; update t2 set filler ='email' where a = 4; select filler,a,hex(b),hex(c) from t1 order by filler; filler a hex(b) hex(c) boo 1 61626364656667 61626364656667 eight 4 D0B1 D0B1 five 4 5B 5B four 4 E880BD E880BD three 3 71727374757677 71727374757677 two 2 696A6B696C6D6E 696A6B696C6D6E select filler,a,hex(b),hex(c) from t2 order by filler; filler a hex(b) hex(c) email 4 0000E400 0000E400 email 4 00640065 00640065 email 4 00E400E50068 00E400E50068 email 4 0120 0120 email 4 01FC 01FC email 4 05612020 05612020 email 4 0563 0563 one 1 61626364656667 61626364656667 three 3 71727374757677 71727374757677 two 2 696A6B696C6D6E 696A6B696C6D6E drop table t1; drop table t2; commit; CREATE TABLE t1 ( ind enum('0','1','2') NOT NULL default '0', string1 varchar(250) NOT NULL, PRIMARY KEY (ind) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. CREATE TABLE t2 ( ind enum('0','1','2') NOT NULL default '0', string1 varchar(250) NOT NULL, PRIMARY KEY (ind) ) ENGINE=InnoDB DEFAULT CHARSET=ucs2; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead INSERT INTO t1 VALUES ('1', ''),('2', ''); INSERT INTO t2 VALUES ('1', ''),('2', ''); 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('0','1','2') NOT NULL default '0', string1 varchar(250) NOT NULL, PRIMARY KEY (ind) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. CREATE TABLE t2 ( ind set('0','1','2') NOT NULL default '0', string1 varchar(250) NOT NULL, PRIMARY KEY (ind) ) ENGINE=InnoDB DEFAULT CHARSET=ucs2; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead INSERT INTO t1 VALUES ('1', ''),('2', ''); INSERT INTO t2 VALUES ('1', ''),('2', ''); 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=InnoDB DEFAULT CHARSET=utf8; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. CREATE TABLE t2 ( ind bit not null, string1 varchar(250) NOT NULL, PRIMARY KEY (ind) ) ENGINE=InnoDB DEFAULT CHARSET=ucs2; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t1 values(0,''),(1,''); insert into t2 values(0,''),(1,''); 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 = innodb; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t2 values (1,'abcdefg','one'); insert into t2 values (2,'ijkilmn','two'); insert into t2 values (3, 'qrstuvw','three'); update t2 set a=5, filler='booo' 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 = innodb; Warnings: Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead insert into t2 values (1,'abcdefg','one'); insert into t2 values (2,'ijkilmn','two'); insert into t2 values (3, 'qrstuvw','three'); update t2 set a=5, filler='booo' where a=1; drop table t2; create table t1(a int not null, b char(110),primary key(a,b(100))) engine=innodb default charset=utf8; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values(1,'abcdefg'),(2,'defghijk'); insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. select a,hex(b) from t1 order by b; a hex(b) 1 61626364656667 2 6465666768696A6B 6 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1 7 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2 update t1 set b = 'three' where a = 6; drop table t1; create table t1(a int not null, b text(110),primary key(a,b(100))) engine=innodb default charset=utf8; Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values(1,'abcdefg'),(2,'defghijk'); insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2); Warnings: Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. select a,hex(b) from t1 order by b; a hex(b) 1 61626364656667 2 6465666768696A6B 6 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1 7 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2 update t1 set b = 'three' where a = 6; drop table t1; End of 5.0 tests