1--source include/have_sjis.inc 2--source include/have_innodb.inc 3--character_set sjis 4--disable_warnings 5drop table if exists `�s�P`; 6drop table if exists `�s�Q`; 7drop table if exists `�s�R`; 8drop table if exists `�s�S`; 9drop table if exists `�s�T`; 10drop table if exists `�s�U`; 11drop table if exists `�s�V`; 12drop table if exists `�s�W`; 13drop table if exists `�s�X`; 14--enable_warnings 15 16# 17# Test LOCATE() function with Japanese characters in sjis encoding 18# 19 20SET NAMES sjis; 21SET character_set_database = sjis; 22CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; 23CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; 24CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; 25CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; 26CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; 27CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; 28CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; 29CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; 30CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; 31 32INSERT INTO `�s�P` VALUES ('�����'); 33INSERT INTO `�s�Q` VALUES ('����������'); 34INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'); 35INSERT INTO `�s�S` VALUES ('�����'); 36INSERT INTO `�s�T` VALUES ('����������'); 37INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'); 38INSERT INTO `�s�V` VALUES ('�����'); 39INSERT INTO `�s�W` VALUES ('����������'); 40INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'); 41 42#InnoDB 43SELECT LOCATE('�',`�b�P`) from `�s�P`; 44SELECT LOCATE('�',`�b�P`) from `�s�P`; 45SELECT LOCATE('�',`�b�P`) from `�s�P`; 46SELECT LOCATE('�',`�b�P`) from `�s�P`; 47SELECT LOCATE('�',`�b�P`) from `�s�P`; 48SELECT LOCATE('�',`�b�P`) from `�s�P`; 49SELECT LOCATE('��',`�b�P`) from `�s�Q`; 50SELECT LOCATE('��',`�b�P`) from `�s�Q`; 51SELECT LOCATE('��',`�b�P`) from `�s�Q`; 52SELECT LOCATE('��',`�b�P`) from `�s�Q`; 53SELECT LOCATE('��',`�b�P`) from `�s�Q`; 54SELECT LOCATE('��',`�b�P`) from `�s�Q`; 55SELECT LOCATE('�\',`�b�P`) from `�s�R`; 56SELECT LOCATE('�\',`�b�P`) from `�s�R`; 57SELECT LOCATE('�\',`�b�P`) from `�s�R`; 58SELECT LOCATE('�\',`�b�P`) from `�s�R`; 59SELECT LOCATE('�\',`�b�P`) from `�s�R`; 60SELECT LOCATE('�\',`�b�P`) from `�s�R`; 61 62#MyISAM 63SELECT LOCATE('�',`�b�P`) from `�s�S`; 64SELECT LOCATE('�',`�b�P`) from `�s�S`; 65SELECT LOCATE('�',`�b�P`) from `�s�S`; 66SELECT LOCATE('�',`�b�P`) from `�s�S`; 67SELECT LOCATE('�',`�b�P`) from `�s�S`; 68SELECT LOCATE('�',`�b�P`) from `�s�S`; 69SELECT LOCATE('��',`�b�P`) from `�s�T`; 70SELECT LOCATE('��',`�b�P`) from `�s�T`; 71SELECT LOCATE('��',`�b�P`) from `�s�T`; 72SELECT LOCATE('��',`�b�P`) from `�s�T`; 73SELECT LOCATE('��',`�b�P`) from `�s�T`; 74SELECT LOCATE('��',`�b�P`) from `�s�T`; 75SELECT LOCATE('�\',`�b�P`) from `�s�U`; 76SELECT LOCATE('�\',`�b�P`) from `�s�U`; 77SELECT LOCATE('�\',`�b�P`) from `�s�U`; 78SELECT LOCATE('�\',`�b�P`) from `�s�U`; 79SELECT LOCATE('�\',`�b�P`) from `�s�U`; 80SELECT LOCATE('�\',`�b�P`) from `�s�U`; 81 82 83#MEMORY 84SELECT LOCATE('�',`�b�P`) from `�s�V`; 85SELECT LOCATE('�',`�b�P`) from `�s�V`; 86SELECT LOCATE('�',`�b�P`) from `�s�V`; 87SELECT LOCATE('�',`�b�P`) from `�s�V`; 88SELECT LOCATE('�',`�b�P`) from `�s�V`; 89SELECT LOCATE('�',`�b�P`) from `�s�V`; 90SELECT LOCATE('��',`�b�P`) from `�s�W`; 91SELECT LOCATE('��',`�b�P`) from `�s�W`; 92SELECT LOCATE('��',`�b�P`) from `�s�W`; 93SELECT LOCATE('��',`�b�P`) from `�s�W`; 94SELECT LOCATE('��',`�b�P`) from `�s�W`; 95SELECT LOCATE('��',`�b�P`) from `�s�W`; 96SELECT LOCATE('�\',`�b�P`) from `�s�X`; 97SELECT LOCATE('�\',`�b�P`) from `�s�X`; 98SELECT LOCATE('�\',`�b�P`) from `�s�X`; 99SELECT LOCATE('�\',`�b�P`) from `�s�X`; 100SELECT LOCATE('�\',`�b�P`) from `�s�X`; 101SELECT LOCATE('�\',`�b�P`) from `�s�X`; 102 103 104DROP TABLE `�s�P`; 105DROP TABLE `�s�Q`; 106DROP TABLE `�s�R`; 107DROP TABLE `�s�S`; 108DROP TABLE `�s�T`; 109DROP TABLE `�s�U`; 110DROP TABLE `�s�V`; 111DROP TABLE `�s�W`; 112DROP TABLE `�s�X`; 113