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