1--source include/have_ujis.inc
2--source include/have_innodb.inc
3
4--disable_warnings
5drop table if exists `�ԣ�`;
6drop table if exists `�ԣ�`;
7drop table if exists `�ԣ�`;
8drop table if exists `�ԣ�`;
9drop table if exists `�ԣ�`;
10drop table if exists `�ԣ�`;
11drop table if exists `�ԣ�`;
12drop table if exists `�ԣ�`;
13drop table if exists `�ԣ�`;
14--enable_warnings
15
16#
17# Test REPLACE() function with Japanese characters in ujis encoding
18#
19
20SET NAMES ujis;
21SET character_set_database = ujis;
22
23CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = innodb;
24CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = innodb;
25CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = innodb;
26CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = myisam;
27CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = myisam;
28CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = myisam;
29CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = MEMORY;
30CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = MEMORY;
31CREATE TABLE `�ԣ�` (`�ã�` char(5)) DEFAULT CHARSET = ujis engine = MEMORY;
32
33INSERT INTO `�ԣ�` VALUES ('����������');
34INSERT INTO `�ԣ�` VALUES ('����������');
35INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
36INSERT INTO `�ԣ�` VALUES ('����������');
37INSERT INTO `�ԣ�` VALUES ('����������');
38INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
39INSERT INTO `�ԣ�` VALUES ('����������');
40INSERT INTO `�ԣ�` VALUES ('����������');
41INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
42
43#InnoDB
44SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
45SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
46SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
47SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
48SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
49SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
50SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
51SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
52SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
53SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
54SELECT REPLACE(`�ã�`,'���','��܏��') FROM `�ԣ�`;
55SELECT REPLACE(`�ã�`,'���','��ݏ��') FROM `�ԣ�`;
56SELECT REPLACE(`�ã�`,'���','��ޏ��') FROM `�ԣ�`;
57SELECT REPLACE(`�ã�`,'���','��ߏ��') FROM `�ԣ�`;
58SELECT REPLACE(`�ã�`,'���','������') FROM `�ԣ�`;
59
60#MyISAM
61SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
62SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
63SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
64SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
65SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
66SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
67SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
68SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
69SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
70SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
71SELECT REPLACE(`�ã�`,'���','��܏��') FROM `�ԣ�`;
72SELECT REPLACE(`�ã�`,'���','��ݏ��') FROM `�ԣ�`;
73SELECT REPLACE(`�ã�`,'���','��ޏ��') FROM `�ԣ�`;
74SELECT REPLACE(`�ã�`,'���','��ߏ��') FROM `�ԣ�`;
75SELECT REPLACE(`�ã�`,'���','������') FROM `�ԣ�`;
76
77#MEMORY
78SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
79SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
80SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
81SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
82SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
83SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
84SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
85SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
86SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
87SELECT REPLACE(`�ã�`,'��','����') FROM `�ԣ�`;
88SELECT REPLACE(`�ã�`,'���','��܏��') FROM `�ԣ�`;
89SELECT REPLACE(`�ã�`,'���','��ݏ��') FROM `�ԣ�`;
90SELECT REPLACE(`�ã�`,'���','��ޏ��') FROM `�ԣ�`;
91SELECT REPLACE(`�ã�`,'���','��ߏ��') FROM `�ԣ�`;
92SELECT REPLACE(`�ã�`,'���','������') FROM `�ԣ�`;
93
94DROP TABLE `�ԣ�`;
95DROP TABLE `�ԣ�`;
96DROP TABLE `�ԣ�`;
97DROP TABLE `�ԣ�`;
98DROP TABLE `�ԣ�`;
99DROP TABLE `�ԣ�`;
100DROP TABLE `�ԣ�`;
101DROP TABLE `�ԣ�`;
102DROP TABLE `�ԣ�`;
103