← Back to branch summary

~drizzle-trunk/drizzle/development

1 by brian
clean slate 
1
 
--source include/have_ujis.inc

2
 









3



--disable_warnings










4



drop table if exists `£Ô£±`;










5



drop table if exists `£Ô£²`;










6



drop table if exists `£Ô£³`;










7



drop table if exists `£Ô£Ž`;










8



drop table if exists `£Ô£µ`;










9



drop table if exists `£Ô£¶`;










10



drop table if exists `£Ô£·`;










11



drop table if exists `£Ô£ž`;










12



drop table if exists `£Ô£¹`;










13



drop table if exists `£Ô£±£°`;










14



drop table if exists `£Ô£±£±`;










15



drop table if exists `£Ô£±£²`;










16



--enable_warnings










17












18



#










19



# Test REPLACE() function with Japanese characters in ujis encoding










20



#










21












22



SET NAMES ujis;










23



SET character_set_database = ujis;










24












25



CREATE TABLE `£Ô£±` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = innodb;










26



CREATE TABLE `£Ô£²` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = innodb;










27



CREATE TABLE `£Ô£³` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = innodb;










28



CREATE TABLE `£Ô£Ž` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = myisam;










29



CREATE TABLE `£Ô£µ` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = myisam;










30



CREATE TABLE `£Ô£¶` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = myisam;










31



CREATE TABLE `£Ô£·` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = heap;










32



CREATE TABLE `£Ô£ž` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = heap;










33



CREATE TABLE `£Ô£¹` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = heap;










34



CREATE TABLE `£Ô£±£°` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = bdb;










35



CREATE TABLE `£Ô£±£±` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = bdb;










36



CREATE TABLE `£Ô£±£²` (`£Ã£±` char(5)) DEFAULT CHARSET = ujis engine = bdb;










37












38



INSERT INTO `£Ô£±` VALUES ('Ž±Ž²Ž³ŽŽŽµ');










39



INSERT INTO `£Ô£²` VALUES ('€¢€€€Š€š€ª');










40



INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà');










41



INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ');










42



INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª');










43



INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà');










44



INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ');










45



INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª');










46



INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà');










47



INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ');










48



INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª');










49



INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà');










50












51



#InnoDB










52



SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£±`;










53



SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£±`;










54



SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£±`;










55



SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£±`;










56



SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£±`;










57



SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£²`;










58



SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£²`;










59



SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£²`;










60



SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£²`;










61



SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£²`;










62



SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£³`;










63



SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£³`;










64



SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£³`;










65



SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£³`;










66



SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£³`;










67












68



#MyISAM










69



SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£Ž`;










70



SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£Ž`;










71



SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£Ž`;










72



SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£Ž`;










73



SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£Ž`;










74



SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£µ`;










75



SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£µ`;










76



SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£µ`;










77



SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£µ`;










78



SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£µ`;










79



SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£¶`;










80



SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£¶`;










81



SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£¶`;










82



SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£¶`;










83



SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£¶`;










84












85



#HEAP










86



SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£·`;










87



SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£·`;










88



SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£·`;










89



SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£·`;










90



SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£·`;










91



SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£ž`;










92



SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£ž`;










93



SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£ž`;










94



SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£ž`;










95



SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£ž`;










96



SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£¹`;










97



SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£¹`;










98



SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£¹`;










99



SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£¹`;










100



SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£¹`;










101












102



#BDB










103



SELECT REPLACE(`£Ã£±`,'Ž±','Ž±Ž±') FROM `£Ô£±£°`;










104



SELECT REPLACE(`£Ã£±`,'Ž²','Ž²Ž²') FROM `£Ô£±£°`;










105



SELECT REPLACE(`£Ã£±`,'Ž³','Ž³Ž³') FROM `£Ô£±£°`;










106



SELECT REPLACE(`£Ã£±`,'ŽŽ','ŽŽŽŽ') FROM `£Ô£±£°`;










107



SELECT REPLACE(`£Ã£±`,'Žµ','ŽµŽµ') FROM `£Ô£±£°`;










108



SELECT REPLACE(`£Ã£±`,'€¢','€¢€¢') FROM `£Ô£±£±`;










109



SELECT REPLACE(`£Ã£±`,'€€','€€€€') FROM `£Ô£±£±`;










110



SELECT REPLACE(`£Ã£±`,'€Š','€Š€Š') FROM `£Ô£±£±`;










111



SELECT REPLACE(`£Ã£±`,'€š','€š€š') FROM `£Ô£±£±`;










112



SELECT REPLACE(`£Ã£±`,'€ª','€ª€ª') FROM `£Ô£±£±`;










113



SELECT REPLACE(`£Ã£±`,'íÜ','í܏íÜ') FROM `£Ô£±£²`;










114



SELECT REPLACE(`£Ã£±`,'íÝ','íݏíÝ') FROM `£Ô£±£²`;










115



SELECT REPLACE(`£Ã£±`,'íÞ','íޏíÞ') FROM `£Ô£±£²`;










116



SELECT REPLACE(`£Ã£±`,'íß','íߏíß') FROM `£Ô£±£²`;










117



SELECT REPLACE(`£Ã£±`,'íà','íàíà') FROM `£Ô£±£²`;










118












119



DROP TABLE `£Ô£±`;










120



DROP TABLE `£Ô£²`;










121



DROP TABLE `£Ô£³`;










122



DROP TABLE `£Ô£Ž`;










123



DROP TABLE `£Ô£µ`;










124



DROP TABLE `£Ô£¶`;










125



DROP TABLE `£Ô£·`;










126



DROP TABLE `£Ô£ž`;










127



DROP TABLE `£Ô£¹`;










128



DROP TABLE `£Ô£±£°`;










129



DROP TABLE `£Ô£±£±`;










130



DROP TABLE `£Ô£±£²`;