~drizzle-trunk/drizzle/development

--source include/have_ujis.inc

--disable_warnings

drop table if exists `£Ô£±`;

drop table if exists `£Ô£²`;

drop table if exists `£Ô£³`;

drop table if exists `£Ô£Ž`;

drop table if exists `£Ô£µ`;

drop table if exists `£Ô£¶`;

drop table if exists `£Ô£·`;

drop table if exists `£Ô£ž`;

drop table if exists `£Ô£¹`;

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

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

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

--enable_warnings

#

# Test LPAD() function with Japanese character in ujis encoding

#

SET NAMES ujis;

SET character_set_database = ujis;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');

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

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

INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');

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

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

INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');

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

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

INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');

#InnoDB

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£±`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£²`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢') FROM `£Ô£³`;

#MyISAM

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£Ž`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£µ`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢' ) FROM `£Ô£¶`;

#HEAP

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£·`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£ž`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢' ) FROM `£Ô£¹`;

#BDB

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£±£°`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£±£±`;

SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢' ) FROM `£Ô£±£²`;

DROP TABLE `£Ô£±`;

DROP TABLE `£Ô£²`;

DROP TABLE `£Ô£³`;

DROP TABLE `£Ô£Ž`;

DROP TABLE `£Ô£µ`;

DROP TABLE `£Ô£¶`;

DROP TABLE `£Ô£·`;

DROP TABLE `£Ô£ž`;

DROP TABLE `£Ô£¹`;

DROP TABLE `£Ô£±£°`;

DROP TABLE `£Ô£±£±`;

DROP TABLE `£Ô£±£²`;