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 REVERSE() function with Japanese characters in ujis encoding 18# 19 20SET NAMES ujis; 21SET character_set_database = ujis; 22 23CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb; 24CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb; 25CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb; 26CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam; 27CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam; 28CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam; 29CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY; 30CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY; 31CREATE TABLE `�ԣ�` (`�ã�` char(5), INDEX(`�ã�`)) 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 REVERSE(`�ã�`) FROM `�ԣ�`; 45SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 46SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 47 48#MyISAM 49SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 50SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 51SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 52 53#MEMORY 54SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 55SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 56SELECT REVERSE(`�ã�`) FROM `�ԣ�`; 57 58DROP TABLE `�ԣ�`; 59DROP TABLE `�ԣ�`; 60DROP TABLE `�ԣ�`; 61DROP TABLE `�ԣ�`; 62DROP TABLE `�ԣ�`; 63DROP TABLE `�ԣ�`; 64DROP TABLE `�ԣ�`; 65DROP TABLE `�ԣ�`; 66DROP TABLE `�ԣ�`; 67