--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`; --enable_warnings # # Test TRIM() function with Japanese characters sjis encoding # SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `�s�P` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Q` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�R` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�S` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�T` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�U` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�V` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�W` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�X` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�O` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; CREATE TABLE `�s�P�P` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; CREATE TABLE `�s�P�Q` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; # Nothing to trim INSERT INTO `�s�P` VALUES ('�����'); # Test data for TRIM(TRAILING [remstr] FROM str) INSERT INTO `�s�P` VALUES ('������'); INSERT INTO `�s�P` VALUES ('�������'); INSERT INTO `�s�P` VALUES ('��������'); # Test data for TRIM(LEADING [remstr] FROM str) INSERT INTO `�s�P` VALUES ('������'); INSERT INTO `�s�P` VALUES ('�������'); INSERT INTO `�s�P` VALUES ('��������'); # Test data for TRIM(BOTH [remstr] FROM str) INSERT INTO `�s�P` VALUES ('�����������'); # Test data for TRIM without [remstr] (remove spaces) INSERT INTO `�s�P` VALUES (' ����� '); INSERT INTO `�s�Q` VALUES ('����������'); INSERT INTO `�s�Q` VALUES ('������������'); INSERT INTO `�s�Q` VALUES ('��������������'); INSERT INTO `�s�Q` VALUES ('����������������'); INSERT INTO `�s�Q` VALUES ('������������'); INSERT INTO `�s�Q` VALUES ('��������������'); INSERT INTO `�s�Q` VALUES ('����������������'); INSERT INTO `�s�Q` VALUES ('����������������������'); INSERT INTO `�s�Q` VALUES (' ���������� '); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\�\�\�\�\'); INSERT INTO `�s�R` VALUES (' �\�\�\�\�\ '); INSERT INTO `�s�S` VALUES ('�����'); INSERT INTO `�s�S` VALUES ('������'); INSERT INTO `�s�S` VALUES ('�������'); INSERT INTO `�s�S` VALUES ('��������'); INSERT INTO `�s�S` VALUES ('������'); INSERT INTO `�s�S` VALUES ('�������'); INSERT INTO `�s�S` VALUES ('��������'); INSERT INTO `�s�S` VALUES ('�����������'); INSERT INTO `�s�S` VALUES (' ����� '); INSERT INTO `�s�T` VALUES ('����������'); INSERT INTO `�s�T` VALUES ('������������'); INSERT INTO `�s�T` VALUES ('��������������'); INSERT INTO `�s�T` VALUES ('����������������'); INSERT INTO `�s�T` VALUES ('������������'); INSERT INTO `�s�T` VALUES ('��������������'); INSERT INTO `�s�T` VALUES ('����������������'); INSERT INTO `�s�T` VALUES ('����������������������'); INSERT INTO `�s�T` VALUES (' ���������� '); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\�\�\�\�\'); INSERT INTO `�s�U` VALUES (' �\�\�\�\�\ '); INSERT INTO `�s�V` VALUES ('�����'); INSERT INTO `�s�V` VALUES ('������'); INSERT INTO `�s�V` VALUES ('�������'); INSERT INTO `�s�V` VALUES ('��������'); INSERT INTO `�s�V` VALUES ('������'); INSERT INTO `�s�V` VALUES ('�������'); INSERT INTO `�s�V` VALUES ('��������'); INSERT INTO `�s�V` VALUES ('�����������'); INSERT INTO `�s�V` VALUES (' ����� '); INSERT INTO `�s�W` VALUES ('����������'); INSERT INTO `�s�W` VALUES ('������������'); INSERT INTO `�s�W` VALUES ('��������������'); INSERT INTO `�s�W` VALUES ('����������������'); INSERT INTO `�s�W` VALUES ('������������'); INSERT INTO `�s�W` VALUES ('��������������'); INSERT INTO `�s�W` VALUES ('����������������'); INSERT INTO `�s�W` VALUES ('����������������������'); INSERT INTO `�s�W` VALUES (' ���������� '); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\�\�\�\�\'); INSERT INTO `�s�X` VALUES (' �\�\�\�\�\ '); INSERT INTO `�s�P�O` VALUES ('�����'); INSERT INTO `�s�P�O` VALUES ('������'); INSERT INTO `�s�P�O` VALUES ('�������'); INSERT INTO `�s�P�O` VALUES ('��������'); INSERT INTO `�s�P�O` VALUES ('������'); INSERT INTO `�s�P�O` VALUES ('�������'); INSERT INTO `�s�P�O` VALUES ('��������'); INSERT INTO `�s�P�O` VALUES ('�����������'); INSERT INTO `�s�P�O` VALUES (' ����� '); INSERT INTO `�s�P�P` VALUES ('����������'); INSERT INTO `�s�P�P` VALUES ('������������'); INSERT INTO `�s�P�P` VALUES ('��������������'); INSERT INTO `�s�P�P` VALUES ('����������������'); INSERT INTO `�s�P�P` VALUES ('������������'); INSERT INTO `�s�P�P` VALUES ('��������������'); INSERT INTO `�s�P�P` VALUES ('����������������'); INSERT INTO `�s�P�P` VALUES ('����������������������'); INSERT INTO `�s�P�P` VALUES (' ���������� '); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\�\�\�\�\'); INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\ '); #InnoDB SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�P`; SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�P`; SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�P`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P`; SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�Q`; SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�Q`; SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�Q`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�Q`; SELECT `�b�P`,TRIM(TRAILING '�\'FROM `�b�P`) FROM `�s�R`; SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�R`; SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�R`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�R`; #MyISAM SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�S`; SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�S`; SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�S`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�S`; SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�T`; SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�T`; SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�T`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�T`; SELECT `�b�P`,TRIM(TRAILING '�\' FROM `�b�P`) FROM `�s�U`; SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�U`; SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�U`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�U`; #HEAP SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�V`; SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�V`; SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�V`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�V`; SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�W`; SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�W`; SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�W`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�W`; SELECT `�b�P`,TRIM(TRAILING '�\' FROM `�b�P`) FROM `�s�X`; SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�X`; SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�X`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�X`; #BDB SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�P�O`; SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�P�O`; SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�P�O`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P�O`; SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�P�P`; SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�P�P`; SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�P�P`; SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P�P`; SELECT `�b�P`,TRIM(TRAILING '�\' FROM `�b�P`) FROM `�s�P�Q`; SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�P�Q`; SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�P�Q`; SELECT `�b�P`,TRIM(`�b�P`) 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`;