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