25
26
CREATE TABLE `�s�S` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
26
27
CREATE TABLE `�s�T` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
27
28
CREATE TABLE `�s�U` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
29
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
30
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
31
CREATE TABLE `�s�P�O` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
32
CREATE TABLE `�s�P�P` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
33
CREATE TABLE `�s�P�Q` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
29
CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
30
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
35
33
INSERT INTO `�s�P` VALUES ('�����');
36
34
INSERT INTO `�s�P` VALUES (' �����');
104
102
INSERT INTO `�s�X` VALUES ('�@�\�\�\�\�\');
105
103
INSERT INTO `�s�X` VALUES ('�@�@�\�\�\�\�\');
106
104
INSERT INTO `�s�X` VALUES ('�@�@�@�\�\�\�\�\');
107
INSERT INTO `�s�P�O` VALUES ('�����');
108
INSERT INTO `�s�P�O` VALUES (' �����');
109
INSERT INTO `�s�P�O` VALUES (' �����');
110
INSERT INTO `�s�P�O` VALUES (' �����');
111
# Double byte spaces are not supposed to be trimed
112
INSERT INTO `�s�P�O` VALUES ('�@�����');
113
INSERT INTO `�s�P�O` VALUES ('�@�@�����');
114
INSERT INTO `�s�P�O` VALUES ('�@�@�@�����');
115
INSERT INTO `�s�P�P` VALUES ('����������');
116
INSERT INTO `�s�P�P` VALUES (' ����������');
117
INSERT INTO `�s�P�P` VALUES (' ����������');
118
INSERT INTO `�s�P�P` VALUES (' ����������');
119
# Double byte spaces are not supposed to be trimed
120
INSERT INTO `�s�P�P` VALUES ('�@����������');
121
INSERT INTO `�s�P�P` VALUES ('�@�@����������');
122
INSERT INTO `�s�P�P` VALUES ('�@�@�@����������');
123
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
124
INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\');
125
INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\');
126
INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\');
127
# Double byte spaces are not supposed to be trimed
128
INSERT INTO `�s�P�Q` VALUES ('�@�\�\�\�\�\');
129
INSERT INTO `�s�P�Q` VALUES ('�@�@�\�\�\�\�\');
130
INSERT INTO `�s�P�Q` VALUES ('�@�@�@�\�\�\�\�\');
133
107
SELECT LTRIM(`�b�P`) from `�s�P`;
139
113
SELECT LTRIM(`�b�P`) from `�s�T`;
140
114
SELECT LTRIM(`�b�P`) from `�s�U`;
143
117
SELECT LTRIM(`�b�P`) from `�s�V`;
144
118
SELECT LTRIM(`�b�P`) from `�s�W`;
145
119
SELECT LTRIM(`�b�P`) from `�s�X`;
148
SELECT LTRIM(`�b�P`) from `�s�P�O`;
149
SELECT LTRIM(`�b�P`) from `�s�P�P`;
150
SELECT LTRIM(`�b�P`) from `�s�P�Q`;
152
121
DROP TABLE `�s�P`;
153
122
DROP TABLE `�s�Q`;
154
123
DROP TABLE `�s�R`;