diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_where_sjis.result')
| -rw-r--r-- | mysql-test/suite/jp/r/jp_where_sjis.result | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_where_sjis.result b/mysql-test/suite/jp/r/jp_where_sjis.result new file mode 100644 index 00000000..536d2a8d --- /dev/null +++ b/mysql-test/suite/jp/r/jp_where_sjis.result @@ -0,0 +1,95 @@ +drop table if exists `sP`; +drop table if exists `sQ`; +drop table if exists `sR`; +drop table if exists `sS`; +drop table if exists `sT`; +drop table if exists `sU`; +drop table if exists `sV`; +drop table if exists `sW`; +drop table if exists `sX`; +SET NAMES sjis; +SET character_set_database = sjis; +CREATE TABLE `sP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sR` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sS` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; +CREATE TABLE `sT` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; +CREATE TABLE `sU` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; +CREATE TABLE `sV` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sW` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sX` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sP`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sU`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`; +SELECT * FROM `sP` WHERE `bP` = 'ฐฑฒณดตถทธนบปผฝพฟ'; +bP +ฐฑฒณดตถทธนบปผฝพฟ +SELECT * FROM `sQ` WHERE `bP` = 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; +bP +E กขฃคฅฆงจฉชซฌญฎฏฐฑ +SELECT * FROM `sR` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\'; +bP +\\\\\\\\\\\\\\\\\\\\ +SELECT * FROM `sS` WHERE `bP` = 'ฐฑฒณดตถทธนบปผฝพฟ'; +bP +ฐฑฒณดตถทธนบปผฝพฟ +SELECT * FROM `sT` WHERE `bP` = 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; +bP +E กขฃคฅฆงจฉชซฌญฎฏฐฑ +SELECT * FROM `sU` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\'; +bP +\\\\\\\\\\\\\\\\\\\\ +SELECT * FROM `sV` WHERE `bP` = 'ฐฑฒณดตถทธนบปผฝพฟ'; +bP +ฐฑฒณดตถทธนบปผฝพฟ +SELECT * FROM `sW` WHERE `bP` = 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; +bP +E กขฃคฅฆงจฉชซฌญฎฏฐฑ +SELECT * FROM `sX` WHERE `bP` = '\\\\\\\\\\\\\\\\\\\\'; +bP +\\\\\\\\\\\\\\\\\\\\ +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +DROP TABLE IF EXISTS t3; +CREATE TABLE t1(c1 char(1)) default charset = sjis engine=innodb; +CREATE TABLE t2(c1 char(1)) default charset = sjis engine=myisam; +CREATE TABLE t3(c1 char(1)) default charset = sjis engine=MEMORY; +INSERT INTO t1 VALUES('S'),('s'); +INSERT INTO t2 VALUES('S'),('s'); +INSERT INTO t3 VALUES('S'),('s'); +SELECT * FROM t1 WHERE c1 = 'S'; +c1 +S +SELECT * FROM t2 WHERE c1 = 'S'; +c1 +S +SELECT * FROM t3 WHERE c1 = 'S'; +c1 +S +SELECT * FROM t1 WHERE c1 = 's'; +c1 +s +SELECT * FROM t2 WHERE c1 = 's'; +c1 +s +SELECT * FROM t3 WHERE c1 = 's'; +c1 +s +DROP TABLE t1; +DROP TABLE t2; +DROP TABLE t3; +DROP TABLE `sP`; +DROP TABLE `sQ`; +DROP TABLE `sR`; +DROP TABLE `sS`; +DROP TABLE `sT`; +DROP TABLE `sU`; +DROP TABLE `sV`; +DROP TABLE `sW`; +DROP TABLE `sX`; |