26
26
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
27
27
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
28
28
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
29
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap;
30
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap;
31
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap;
32
CREATE TABLE `�ԣ���` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb;
33
CREATE TABLE `�ԣ���` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb;
34
CREATE TABLE `�ԣ���` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb;
29
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
30
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
31
CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
36
33
INSERT INTO `�ԣ�` VALUES ('����������');
37
34
INSERT INTO `�ԣ�` VALUES (' ����������');
105
102
INSERT INTO `�ԣ�` VALUES ('�����ݏ�ޏ�ߏ��');
106
103
INSERT INTO `�ԣ�` VALUES ('�������ݏ�ޏ�ߏ��');
107
104
INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��');
108
INSERT INTO `�ԣ���` VALUES ('����������');
109
INSERT INTO `�ԣ���` VALUES (' ����������');
110
INSERT INTO `�ԣ���` VALUES (' ����������');
111
INSERT INTO `�ԣ���` VALUES (' ����������');
112
# Double byte spaces are not supposed to be trimed
113
INSERT INTO `�ԣ���` VALUES ('������������');
114
INSERT INTO `�ԣ���` VALUES ('��������������');
115
INSERT INTO `�ԣ���` VALUES ('����������������');
116
INSERT INTO `�ԣ���` VALUES ('����������');
117
INSERT INTO `�ԣ���` VALUES (' ����������');
118
INSERT INTO `�ԣ���` VALUES (' ����������');
119
INSERT INTO `�ԣ���` VALUES (' ����������');
120
# Double byte spaces are not supposed to be trimed
121
INSERT INTO `�ԣ���` VALUES ('������������');
122
INSERT INTO `�ԣ���` VALUES ('��������������');
123
INSERT INTO `�ԣ���` VALUES ('����������������');
124
INSERT INTO `�ԣ���` VALUES ('���ݏ�ޏ�ߏ��');
125
INSERT INTO `�ԣ���` VALUES (' ���ݏ�ޏ�ߏ��');
126
INSERT INTO `�ԣ���` VALUES (' ���ݏ�ޏ�ߏ��');
127
INSERT INTO `�ԣ���` VALUES (' ���ݏ�ޏ�ߏ��');
128
# Double byte spaces are not supposed to be trimed
129
INSERT INTO `�ԣ���` VALUES ('�����ݏ�ޏ�ߏ��');
130
INSERT INTO `�ԣ���` VALUES ('�������ݏ�ޏ�ߏ��');
131
INSERT INTO `�ԣ���` VALUES ('���������ݏ�ޏ�ߏ��');
134
107
SELECT LTRIM(`�ã�`) from `�ԣ�`;
140
113
SELECT LTRIM(`�ã�`) from `�ԣ�`;
141
114
SELECT LTRIM(`�ã�`) from `�ԣ�`;
144
117
SELECT LTRIM(`�ã�`) from `�ԣ�`;
145
118
SELECT LTRIM(`�ã�`) from `�ԣ�`;
146
119
SELECT LTRIM(`�ã�`) from `�ԣ�`;
149
SELECT LTRIM(`�ã�`) from `�ԣ���`;
150
SELECT LTRIM(`�ã�`) from `�ԣ���`;
151
SELECT LTRIM(`�ã�`) from `�ԣ���`;
153
121
DROP TABLE `�ԣ�`;
154
122
DROP TABLE `�ԣ�`;
155
123
DROP TABLE `�ԣ�`;