1--source include/have_sjis.inc
2--source include/have_innodb.inc
3--character_set sjis
4--disable_warnings
5drop table if exists `�s�P`;
6drop table if exists `�s�Q`;
7drop table if exists `�s�R`;
8drop table if exists `�s�S`;
9drop table if exists `�s�T`;
10drop table if exists `�s�U`;
11drop table if exists `�s�V`;
12drop table if exists `�s�W`;
13drop table if exists `�s�X`;
14--enable_warnings
15
16#
17# Test CHAR_LENGTH() function with Japanese character in sjis encoding
18#
19
20SET NAMES sjis;
21SET character_set_database = sjis;
22
23CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
24CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
26CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
27CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
29CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
30CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
32
33INSERT INTO `�s�P` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
34INSERT INTO `�s�Q` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
35INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
36INSERT INTO `�s�S` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
37INSERT INTO `�s�T` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
38INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
39INSERT INTO `�s�V` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
40INSERT INTO `�s�W` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
41INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
42
43#InnoDB
44SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�P`;
45SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�Q`;
46SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�R`;
47
48#MyISAM
49SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�S`;
50SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�T`;
51SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�U`;
52
53#MEMORY
54SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�V`;
55SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�W`;
56SELECT `�b�P`, CHAR_LENGTH(`�b�P`) FROM `�s�X`;
57
58DROP TABLE `�s�P`;
59DROP TABLE `�s�Q`;
60DROP TABLE `�s�R`;
61DROP TABLE `�s�S`;
62DROP TABLE `�s�T`;
63DROP TABLE `�s�U`;
64DROP TABLE `�s�V`;
65DROP TABLE `�s�W`;
66DROP TABLE `�s�X`;
67