← 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 CHARSET() function with Japanese characters in ujis encoding  










20



#










21












22



SET NAMES ujis;










23



SET character_set_database = ujis;










24












25



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










26



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










27



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










28



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










29



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










30



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










31



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










32



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










33



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










34



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










35



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










36



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










37












38



#Load the following data in each table










39



# jisx0201 hankaku-katakana data










40



# jisx0208 data










41



# jisx0212 supplemental character data










42












43



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£±`;










44



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£²`;










45



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£³`; 










46



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£Ž`;










47



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£µ`;










48



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£¶`;










49



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£·`;










50



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£ž`;










51



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£¹`;










52



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£±£°`;










53



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£±£±`;










54



 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£±£²`;










55












56



#InnoDB










57



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±`;










58



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£²`;










59



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£³`;










60



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±`;










61



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±`;










62



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±`;










63



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±`;










64



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£²`;










65



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£²`;










66



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£²`;










67



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£²`;










68



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£³`;










69



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£³`;










70



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£³`;










71



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£³`;










72












73



#MyISAM










74



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£Ž`;










75



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£µ`;










76



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£¶`;










77



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£Ž`;










78



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£Ž`;










79



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£Ž`;










80



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£Ž`;










81



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£µ`;










82



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£µ`;










83



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£µ`;










84



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£µ`;










85



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£¶`;










86



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£¶`;










87



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£¶`;










88



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£¶`;










89












90



#Heap










91



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£·`;










92



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£ž`;










93



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£¹`;










94



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£·`;










95



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£·`;










96



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£·`;










97



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£·`;










98



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£ž`;










99



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£ž`;










100



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£ž`;










101



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£ž`;










102



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£¹`;










103



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£¹`;










104



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£¹`;










105



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£¹`;










106












107



#BDB










108



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±£°`;










109



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±£±`;










110



SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±£²`;










111



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±£°`;










112



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±£°`;










113



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±£°`;










114



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±£°`;










115



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±£±`;










116



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±£±`;










117



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±£±`;










118



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±£±`;










119



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±£²`;










120



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±£²`;










121



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±£²`;










122



SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±£²`;










123












124



drop table `£Ô£±`;










125



drop table `£Ô£²`;










126



drop table `£Ô£³`;










127



drop table `£Ô£Ž`;










128



drop table `£Ô£µ`;










129



drop table `£Ô£¶`;










130



drop table `£Ô£·`;










131



drop table `£Ô£ž`;










132



drop table `£Ô£¹`;










133



drop table `£Ô£±£°`;










134



drop table `£Ô£±£±`;










135



drop table `£Ô£±£²`;