--character_set sjis --disable_warnings drop table if exists `�s�P`; drop table if exists `�s�Q`; drop table if exists `�s�R`; drop table if exists `�s�S`; drop table if exists `�s�T`; drop table if exists `�s�U`; drop table if exists `�s�V`; drop table if exists `�s�W`; drop table if exists `�s�X`; drop table if exists `�s�P�O`; drop table if exists `�s�P�P`; drop table if exists `�s�P�Q`; --enable_warnings # # Test RPAD() function with Japanese character in sjis encoding # SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; INSERT INTO `�s�P` VALUES ('�����'),('����'),('���'),('��'),('�'),(''); INSERT INTO `�s�Q` VALUES ('����������'),('��������'),('������'),('����'),('��'),(''); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),(''); INSERT INTO `�s�S` VALUES ('�����'),('����'),('���'),('��'),('�'),(''); INSERT INTO `�s�T` VALUES ('����������'),('��������'),('������'),('����'),('��'),(''); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),(''); INSERT INTO `�s�V` VALUES ('�����'),('����'),('���'),('��'),('�'),(''); INSERT INTO `�s�W` VALUES ('����������'),('��������'),('������'),('����'),('��'),(''); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),(''); INSERT INTO `�s�P�O` VALUES ('�����'),('����'),('���'),('��'),('�'),(''); INSERT INTO `�s�P�P` VALUES ('����������'),('��������'),('������'),('����'),('��'),(''); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),(''); #InnoDB SELECT `�b�P`, RPAD(`�b�P`,5,'�') FROM `�s�P`; SELECT `�b�P`, RPAD(`�b�P`,5,'�w') FROM `�s�Q`; SELECT `�b�P`, RPAD(`�b�P`,5,'�\') FROM `�s�R`; #MyISAM SELECT `�b�P`, RPAD(`�b�P`,5,'�') FROM `�s�S`; SELECT `�b�P`, RPAD(`�b�P`,5,'�w') FROM `�s�T`; SELECT `�b�P`, RPAD(`�b�P`,5,'�\' ) FROM `�s�U`; #HEAP SELECT `�b�P`, RPAD(`�b�P`,5,'�') FROM `�s�V`; SELECT `�b�P`, RPAD(`�b�P`,5,'�w') FROM `�s�W`; SELECT `�b�P`, RPAD(`�b�P`,5,'�\' ) FROM `�s�X`; #BDB SELECT `�b�P`, RPAD(`�b�P`,5,'�') FROM `�s�P�O`; SELECT `�b�P`, RPAD(`�b�P`,5,'�w') FROM `�s�P�P`; SELECT `�b�P`, RPAD(`�b�P`,5,'�\' ) FROM `�s�P�Q`; DROP TABLE `�s�P`; DROP TABLE `�s�Q`; DROP TABLE `�s�R`; DROP TABLE `�s�S`; DROP TABLE `�s�T`; DROP TABLE `�s�U`; DROP TABLE `�s�V`; DROP TABLE `�s�W`; DROP TABLE `�s�X`; DROP TABLE `�s�P�O`; DROP TABLE `�s�P�P`; DROP TABLE `�s�P�Q`;