Debian Codegraph @

mysql-test/suite/jp/r/jp_reverse_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 Warnings:
12 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.
13 SET character_set_database = utf8;
14 Warnings:
15 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.
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
17 CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18 Warnings:
19 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.
20 CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
21 Warnings:
22 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.
23 CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 Warnings:
25 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.
26 CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 Warnings:
28 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.
29 CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 Warnings:
31 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.
32 CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
33 Warnings:
34 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.
35 CREATE TABLE `T7` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
36 Warnings:
37 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.
38 CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
39 Warnings:
40 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.
41 CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
42 Warnings:
43 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.
44 INSERT INTO `T1` VALUES ('アイウエオ');
45 INSERT INTO `T2` VALUES ('あいうえお');
46 INSERT INTO `T3` VALUES ('龔龖龗龞龡');
47 INSERT INTO `T4` VALUES ('アイウエオ');
48 INSERT INTO `T5` VALUES ('あいうえお');
49 INSERT INTO `T6` VALUES ('龔龖龗龞龡');
50 INSERT INTO `T7` VALUES ('アイウエオ');
51 INSERT INTO `T8` VALUES ('あいうえお');
52 INSERT INTO `T9` VALUES ('龔龖龗龞龡');
53 SELECT REVERSE(`C1`) FROM `T1`;
54 REVERSE(`C1`)
55 オエウイア
56 SELECT REVERSE(`C1`) FROM `T2`;
57 REVERSE(`C1`)
58 おえういあ
59 SELECT REVERSE(`C1`) FROM `T3`;
60 REVERSE(`C1`)
61 龡龞龗龖龔
62 SELECT REVERSE(`C1`) FROM `T4`;
63 REVERSE(`C1`)
64 オエウイア
65 SELECT REVERSE(`C1`) FROM `T5`;
66 REVERSE(`C1`)
67 おえういあ
68 SELECT REVERSE(`C1`) FROM `T6`;
69 REVERSE(`C1`)
70 龡龞龗龖龔
71 SELECT REVERSE(`C1`) FROM `T7`;
72 REVERSE(`C1`)
73 オエウイア
74 SELECT REVERSE(`C1`) FROM `T8`;
75 REVERSE(`C1`)
76 おえういあ
77 SELECT REVERSE(`C1`) FROM `T9`;
78 REVERSE(`C1`)
79 龡龞龗龖龔
80 DROP TABLE `T1`;
81 DROP TABLE `T2`;
82 DROP TABLE `T3`;
83 DROP TABLE `T4`;
84 DROP TABLE `T5`;
85 DROP TABLE `T6`;
86 DROP TABLE `T7`;
87 DROP TABLE `T8`;
88 DROP TABLE `T9`;