1 --source include/have_sjis.inc
2 --source include/have_innodb.inc
5 drop table if exists `‚s‚P`;
6 drop table if exists `‚s‚Q`;
7 drop table if exists `‚s‚R`;
8 drop table if exists `‚s‚S`;
9 drop table if exists `‚s‚T`;
10 drop table if exists `‚s‚U`;
11 drop table if exists `‚s‚V`;
12 drop table if exists `‚s‚W`;
13 drop table if exists `‚s‚X`;
17 # Test CHAR_LENGTH() function with Japanese character in sjis encoding
21 SET character_set_database = sjis;
23 CREATE TABLE `‚s‚P` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
24 CREATE TABLE `‚s‚Q` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
25 CREATE TABLE `‚s‚R` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
26 CREATE TABLE `‚s‚S` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
27 CREATE TABLE `‚s‚T` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
28 CREATE TABLE `‚s‚U` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
29 CREATE TABLE `‚s‚V` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
30 CREATE TABLE `‚s‚W` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31 CREATE TABLE `‚s‚X` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
33 INSERT INTO `‚s‚P` VALUES ('±²³´µ'),('±²³´'),('±²³'),('±²'),('±'),('');
34 INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨'),('‚ ‚¢‚¤‚¦'),('‚ ‚¢‚¤'),('‚ ‚¢'),('‚ '),('');
35 INSERT INTO `‚s‚R` VALUES ('ƒ\�\•\—\�\'),('ƒ\�\•\—\'),('ƒ\�\•\'),('ƒ\�\'),('ƒ\'),('');
36 INSERT INTO `‚s‚S` VALUES ('±²³´µ'),('±²³´'),('±²³'),('±²'),('±'),('');
37 INSERT INTO `‚s‚T` VALUES ('‚ ‚¢‚¤‚¦‚¨'),('‚ ‚¢‚¤‚¦'),('‚ ‚¢‚¤'),('‚ ‚¢'),('‚ '),('');
38 INSERT INTO `‚s‚U` VALUES ('ƒ\�\•\—\�\'),('ƒ\�\•\—\'),('ƒ\�\•\'),('ƒ\�\'),('ƒ\'),('');
39 INSERT INTO `‚s‚V` VALUES ('±²³´µ'),('±²³´'),('±²³'),('±²'),('±'),('');
40 INSERT INTO `‚s‚W` VALUES ('‚ ‚¢‚¤‚¦‚¨'),('‚ ‚¢‚¤‚¦'),('‚ ‚¢‚¤'),('‚ ‚¢'),('‚ '),('');
41 INSERT INTO `‚s‚X` VALUES ('ƒ\�\•\—\�\'),('ƒ\�\•\—\'),('ƒ\�\•\'),('ƒ\�\'),('ƒ\'),('');
44 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚P`;
45 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚Q`;
46 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚R`;
49 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚S`;
50 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚T`;
51 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚U`;
54 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚V`;
55 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚W`;
56 SELECT `‚b‚P`, CHAR_LENGTH(`‚b‚P`) FROM `‚s‚X`;