16
16
CREATE TEMPORARY TABLE `T7` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
17
17
CREATE TEMPORARY TABLE `T8` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
18
18
CREATE TEMPORARY TABLE `T9` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
19
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T1`;
20
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T2`;
22
Note 1265 Data truncated for column 'C1' at row 30
23
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T3`;
24
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T4`;
25
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T5`;
27
Note 1265 Data truncated for column 'C1' at row 30
28
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T6`;
29
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T7`;
30
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T8`;
32
Note 1265 Data truncated for column 'C1' at row 30
33
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T9`;
19
LOAD DATA INFILE '../../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T1`;
20
LOAD DATA INFILE '../../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T2`;
21
ERROR 22001: Data too long for column 'C1' at row 30
22
LOAD DATA INFILE '../../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T3`;
23
LOAD DATA INFILE '../../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T4`;
24
LOAD DATA INFILE '../../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T5`;
25
ERROR 22001: Data too long for column 'C1' at row 30
26
LOAD DATA INFILE '../../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T6`;
27
LOAD DATA INFILE '../../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T7`;
28
LOAD DATA INFILE '../../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T8`;
29
ERROR 22001: Data too long for column 'C1' at row 30
30
LOAD DATA INFILE '../../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T9`;
34
31
SELECT * FROM `T1` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
37
34
SELECT * FROM `T2` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
40
36
SELECT * FROM `T3` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
42
38
鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖