Debian Codegraph @

mysql-test/suite/jp/r/jp_update_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 UPDATE `T1` SET `C1` = ('カキクケコ');
54 UPDATE `T2` SET `C1` = ('かきくけこ');
55 UPDATE `T3` SET `C1` = ('齗齘齚齝齞');
56 UPDATE `T4` SET `C1` = ('カキクケコ');
57 UPDATE `T5` SET `C1` = ('かきくけこ');
58 UPDATE `T6` SET `C1` = ('齗齘齚齝齞');
59 UPDATE `T7` SET `C1` = ('カキクケコ');
60 UPDATE `T8` SET `C1` = ('かきくけこ');
61 UPDATE `T9` SET `C1` = ('齗齘齚齝齞');
62 SELECT * FROM `T1`;
63 C1
64 カキクケコ
65 SELECT * FROM `T2`;
66 C1
67 かきくけこ
68 SELECT * FROM `T3`;
69 C1
70 齗齘齚齝齞
71 SELECT * FROM `T4`;
72 C1
73 カキクケコ
74 SELECT * FROM `T5`;
75 C1
76 かきくけこ
77 SELECT * FROM `T6`;
78 C1
79 齗齘齚齝齞
80 SELECT * FROM `T7`;
81 C1
82 カキクケコ
83 SELECT * FROM `T8`;
84 C1
85 かきくけこ
86 SELECT * FROM `T9`;
87 C1
88 齗齘齚齝齞
89 DROP TABLE `T1`;
90 DROP TABLE `T2`;
91 DROP TABLE `T3`;
92 DROP TABLE `T4`;
93 DROP TABLE `T5`;
94 DROP TABLE `T6`;
95 DROP TABLE `T7`;
96 DROP TABLE `T8`;
97 DROP TABLE `T9`;