Debian Codegraph @

mysql-test/suite/jp/r/jp_length_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 `C1`, LENGTH(`C1`) FROM `T1`;
54 C1 LENGTH(`C1`)
55 0
56 ア 3
57 アイ 6
58 アイウ 9
59 アイウエ 12
60 アイウエオ 15
61 SELECT `C1`, LENGTH(`C1`) FROM `T2`;
62 C1 LENGTH(`C1`)
63 0
64 あ 3
65 あい 6
66 あいう 9
67 あいうえ 12
68 あいうえお 15
69 SELECT `C1`, LENGTH(`C1`) FROM `T3`;
70 C1 LENGTH(`C1`)
71 0
72 龔 3
73 龔龖 6
74 龔龖龗 9
75 龔龖龗龞 12
76 龔龖龗龞龡 15
77 SELECT `C1`, LENGTH(`C1`) FROM `T4`;
78 C1 LENGTH(`C1`)
79 0
80 ア 3
81 アイ 6
82 アイウ 9
83 アイウエ 12
84 アイウエオ 15
85 SELECT `C1`, LENGTH(`C1`) FROM `T5`;
86 C1 LENGTH(`C1`)
87 0
88 あ 3
89 あい 6
90 あいう 9
91 あいうえ 12
92 あいうえお 15
93 SELECT `C1`, LENGTH(`C1`) FROM `T6`;
94 C1 LENGTH(`C1`)
95 0
96 龔 3
97 龔龖 6
98 龔龖龗 9
99 龔龖龗龞 12
100 龔龖龗龞龡 15
101 SELECT `C1`, LENGTH(`C1`) FROM `T7`;
102 C1 LENGTH(`C1`)
103 アイウエオ 15
104 アイウエ 12
105 アイウ 9
106 アイ 6
107 ア 3
108 0
109 SELECT `C1`, LENGTH(`C1`) FROM `T8`;
110 C1 LENGTH(`C1`)
111 あいうえお 15
112 あいうえ 12
113 あいう 9
114 あい 6
115 あ 3
116 0
117 SELECT `C1`, LENGTH(`C1`) FROM `T9`;
118 C1 LENGTH(`C1`)
119 龔龖龗龞龡 15
120 龔龖龗龞 12
121 龔龖龗 9
122 龔龖 6
123 龔 3
124 0
125 DROP TABLE `T1`;
126 DROP TABLE `T2`;
127 DROP TABLE `T3`;
128 DROP TABLE `T4`;
129 DROP TABLE `T5`;
130 DROP TABLE `T6`;
131 DROP TABLE `T7`;
132 DROP TABLE `T8`;
133 DROP TABLE `T9`;