mariadb/mysql-test/suite/jp/t/jp_where_utf8.test
2024-05-24 15:50:57 +04:00

71 lines
3.4 KiB
Text
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

--source include/have_utf8.inc
--source include/have_innodb.inc
--disable_warnings
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
--enable_warnings
#
# Test Displaying Japanese charact using WHERE condition in utf8 encoding
#
SET character_set_collations='utf8mb3=utf8mb3_general_ci';
SET NAMES utf8;
SET character_set_database = utf8;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `` (`` char(20), INDEX(``)) DEFAULT CHARSET = utf8 engine = MEMORY;
#Load the following data in each table
# jisx0201 hankaku-katakana data
# jisx0208 data
# jisx0212 supplemental character data
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE ``;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE ``;
#InnoDB
SELECT * FROM `` WHERE `` = 'ーアイウエオカキクケコサシスセソ';
SELECT * FROM `` WHERE `` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
SELECT * FROM `` WHERE `` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
#MyISAM
SELECT * FROM `` WHERE `` = 'ーアイウエオカキクケコサシスセソ';
SELECT * FROM `` WHERE `` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
SELECT * FROM `` WHERE `` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
#MEMORY
SELECT * FROM `` WHERE `` = 'ーアイウエオカキクケコサシスセソ';
SELECT * FROM `` WHERE `` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
SELECT * FROM `` WHERE `` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;