3
drop table if exists `�s�P`;
4
drop table if exists `�s�Q`;
5
drop table if exists `�s�R`;
6
drop table if exists `�s�S`;
7
drop table if exists `�s�T`;
8
drop table if exists `�s�U`;
9
drop table if exists `�s�V`;
10
drop table if exists `�s�W`;
11
drop table if exists `�s�X`;
12
drop table if exists `�s�P�O`;
13
drop table if exists `�s�P�P`;
14
drop table if exists `�s�P�Q`;
18
# Test REPLACE() function with Japanese characters in sjis encoding
22
SET character_set_database = sjis;
24
CREATE TABLE `�s�P` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�Q` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = innodb;
26
CREATE TABLE `�s�R` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = innodb;
27
CREATE TABLE `�s�S` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�T` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
29
CREATE TABLE `�s�U` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
30
CREATE TABLE `�s�V` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = heap;
31
CREATE TABLE `�s�W` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = heap;
32
CREATE TABLE `�s�X` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = heap;
33
CREATE TABLE `�s�P�O` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = bdb;
34
CREATE TABLE `�s�P�P` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = bdb;
35
CREATE TABLE `�s�P�Q` (`�b�P` char(5)) DEFAULT CHARSET = sjis engine = bdb;
37
INSERT INTO `�s�P` VALUES ('�����');
38
INSERT INTO `�s�Q` VALUES ('����������');
39
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
40
INSERT INTO `�s�S` VALUES ('�����');
41
INSERT INTO `�s�T` VALUES ('����������');
42
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
43
INSERT INTO `�s�V` VALUES ('�����');
44
INSERT INTO `�s�W` VALUES ('����������');
45
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
46
INSERT INTO `�s�P�O` VALUES ('�����');
47
INSERT INTO `�s�P�P` VALUES ('����������');
48
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
51
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P`;
52
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P`;
53
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P`;
54
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P`;
55
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P`;
56
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�Q`;
57
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�Q`;
58
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�Q`;
59
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�Q`;
60
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�Q`;
61
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�R`;
62
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�R`;
63
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�R`;
64
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�R`;
65
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�R`;
68
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�S`;
69
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�S`;
70
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�S`;
71
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�S`;
72
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�S`;
73
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�T`;
74
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�T`;
75
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�T`;
76
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�T`;
77
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�T`;
78
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�U`;
79
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�U`;
80
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�U`;
81
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�U`;
82
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�U`;
85
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�V`;
86
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�V`;
87
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�V`;
88
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�V`;
89
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�V`;
90
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�W`;
91
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�W`;
92
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�W`;
93
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�W`;
94
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�W`;
95
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�X`;
96
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�X`;
97
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�X`;
98
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�X`;
99
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�X`;
102
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
103
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
104
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
105
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
106
SELECT REPLACE(`�b�P`,'�','��') FROM `�s�P�O`;
107
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
108
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
109
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
110
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
111
SELECT REPLACE(`�b�P`,'��','����') FROM `�s�P�P`;
112
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
113
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
114
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
115
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;
116
SELECT REPLACE(`�b�P`,'�\','�\�\') FROM `�s�P�Q`;