1--source include/have_ucs2.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 LTRIM() function with Japanese characters in ucs2 encoding 18# 19 20SET NAMES ujis; 21SET character_set_database = ucs2; 22SET collation_connection = ucs2_general_ci; 23 24CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb; 25CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb; 26CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb; 27CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam; 28CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam; 29CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam; 30CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY; 31CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY; 32CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY; 33 34INSERT INTO `�ԣ�` VALUES ('����������'); 35INSERT INTO `�ԣ�` VALUES (' ����������'); 36INSERT INTO `�ԣ�` VALUES (' ����������'); 37INSERT INTO `�ԣ�` VALUES (' ����������'); 38# Double byte spaces are not supposed to be trimed 39INSERT INTO `�ԣ�` VALUES ('������������'); 40INSERT INTO `�ԣ�` VALUES ('��������������'); 41INSERT INTO `�ԣ�` VALUES ('����������������'); 42INSERT INTO `�ԣ�` VALUES ('����������'); 43INSERT INTO `�ԣ�` VALUES (' ����������'); 44INSERT INTO `�ԣ�` VALUES (' ����������'); 45INSERT INTO `�ԣ�` VALUES (' ����������'); 46# Double byte spaces are not supposed to be trimed 47INSERT INTO `�ԣ�` VALUES ('������������'); 48INSERT INTO `�ԣ�` VALUES ('��������������'); 49INSERT INTO `�ԣ�` VALUES ('����������������'); 50INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ��'); 51INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 52INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 53INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 54# Double byte spaces are not supposed to be trimed 55INSERT INTO `�ԣ�` VALUES ('�����ݏ�ޏ�ߏ��'); 56INSERT INTO `�ԣ�` VALUES ('�������ݏ�ޏ�ߏ��'); 57INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��'); 58INSERT INTO `�ԣ�` VALUES ('����������'); 59INSERT INTO `�ԣ�` VALUES (' ����������'); 60INSERT INTO `�ԣ�` VALUES (' ����������'); 61INSERT INTO `�ԣ�` VALUES (' ����������'); 62# Double byte spaces are not supposed to be trimed 63INSERT INTO `�ԣ�` VALUES ('������������'); 64INSERT INTO `�ԣ�` VALUES ('��������������'); 65INSERT INTO `�ԣ�` VALUES ('����������������'); 66INSERT INTO `�ԣ�` VALUES ('����������'); 67INSERT INTO `�ԣ�` VALUES (' ����������'); 68INSERT INTO `�ԣ�` VALUES (' ����������'); 69INSERT INTO `�ԣ�` VALUES (' ����������'); 70# Double byte spaces are not supposed to be trimed 71INSERT INTO `�ԣ�` VALUES ('������������'); 72INSERT INTO `�ԣ�` VALUES ('��������������'); 73INSERT INTO `�ԣ�` VALUES ('����������������'); 74INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ��'); 75INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 76INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 77INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 78# Double byte spaces are not supposed to be trimed 79INSERT INTO `�ԣ�` VALUES ('�����ݏ�ޏ�ߏ��'); 80INSERT INTO `�ԣ�` VALUES ('�������ݏ�ޏ�ߏ��'); 81INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��'); 82INSERT INTO `�ԣ�` VALUES ('����������'); 83INSERT INTO `�ԣ�` VALUES (' ����������'); 84INSERT INTO `�ԣ�` VALUES (' ����������'); 85INSERT INTO `�ԣ�` VALUES (' ����������'); 86# Double byte spaces are not supposed to be trimed 87INSERT INTO `�ԣ�` VALUES ('������������'); 88INSERT INTO `�ԣ�` VALUES ('��������������'); 89INSERT INTO `�ԣ�` VALUES ('����������������'); 90INSERT INTO `�ԣ�` VALUES ('����������'); 91INSERT INTO `�ԣ�` VALUES (' ����������'); 92INSERT INTO `�ԣ�` VALUES (' ����������'); 93INSERT INTO `�ԣ�` VALUES (' ����������'); 94# Double byte spaces are not supposed to be trimed 95INSERT INTO `�ԣ�` VALUES ('������������'); 96INSERT INTO `�ԣ�` VALUES ('��������������'); 97INSERT INTO `�ԣ�` VALUES ('����������������'); 98INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ��'); 99INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 100INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 101INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ��'); 102# Double byte spaces are not supposed to be trimed 103INSERT INTO `�ԣ�` VALUES ('�����ݏ�ޏ�ߏ��'); 104INSERT INTO `�ԣ�` VALUES ('�������ݏ�ޏ�ߏ��'); 105INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��'); 106 107#InnoDB 108SELECT LTRIM(`�ã�`) from `�ԣ�`; 109SELECT LTRIM(`�ã�`) from `�ԣ�`; 110SELECT LTRIM(`�ã�`) from `�ԣ�`; 111 112#MyISAM 113SELECT LTRIM(`�ã�`) from `�ԣ�`; 114SELECT LTRIM(`�ã�`) from `�ԣ�`; 115SELECT LTRIM(`�ã�`) from `�ԣ�`; 116 117#MEMORY 118SELECT LTRIM(`�ã�`) from `�ԣ�`; 119SELECT LTRIM(`�ã�`) from `�ԣ�`; 120SELECT LTRIM(`�ã�`) from `�ԣ�`; 121 122DROP TABLE `�ԣ�`; 123DROP TABLE `�ԣ�`; 124DROP TABLE `�ԣ�`; 125DROP TABLE `�ԣ�`; 126DROP TABLE `�ԣ�`; 127DROP TABLE `�ԣ�`; 128DROP TABLE `�ԣ�`; 129DROP TABLE `�ԣ�`; 130DROP TABLE `�ԣ�`; 131