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