mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-02-10 23:45:34 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/jp/r/jp_charset_sjis.result
Rucha Deodhar 2fdb556e04 MDEV-8334: Rename utf8 to utf8mb3 
This patch changes the main name of 3 byte character set from utf8 to
utf8mb3. New old_mode UTF8_IS_UTF8MB3 is added and set TRUE by default,
so that utf8 would mean utf8mb3. If not set, utf8 would mean utf8mb4.
2021-05-19 06:48:36 +02:00

173 lines
6.2 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.

drop table if exists `‚s‚P`;
drop table if exists `‚s‚Q`;
drop table if exists `‚s‚R`;
drop table if exists `‚s‚S`;
drop table if exists `‚s‚T`;
drop table if exists `‚s‚U`;
drop table if exists `‚s‚V`;
drop table if exists `‚s‚W`;
drop table if exists `‚s‚X`;
SET NAMES sjis;
SET character_set_database = sjis;
CREATE TABLE `‚s‚P` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `‚s‚Q` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `‚s‚R` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `‚s‚S` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `‚s‚T` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `‚s‚U` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `‚s‚V` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `‚s‚W` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `‚s‚X` (`‚b‚P` char(20)) DEFAULT CHARSET = sjis engine = MEMORY;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚P`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚Q`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚R`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚S`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚T`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚U`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚V`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚W`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚X`;
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚P`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚Q`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚R`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚P`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚P`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚P`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚P`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚Q`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚Q`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚Q`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚Q`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚R`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚R`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚R`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚R`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚S`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚T`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚U`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚S`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚S`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚S`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚S`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚T`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚T`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚T`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚T`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚U`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚U`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚U`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚U`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚V`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚W`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(`‚b‚P`) FROM `‚s‚X`;
CHARSET(`‚b‚P`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚V`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚V`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚V`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚V`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚W`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚W`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚W`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚W`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING utf8)) FROM `‚s‚X`;
CHARSET(CONVERT(`‚b‚P` USING utf8))
utf8mb3
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ucs2)) FROM `‚s‚X`;
CHARSET(CONVERT(`‚b‚P` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING sjis)) FROM `‚s‚X`;
CHARSET(CONVERT(`‚b‚P` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`‚b‚P` USING ujis)) FROM `‚s‚X`;
CHARSET(CONVERT(`‚b‚P` USING ujis))
ujis
drop table `‚s‚P`;
drop table `‚s‚Q`;
drop table `‚s‚R`;
drop table `‚s‚S`;
drop table `‚s‚T`;
drop table `‚s‚U`;
drop table `‚s‚V`;
drop table `‚s‚W`;
drop table `‚s‚X`;
Reference in a new issue View git blame Copy permalink