4493d40a-92aa-4162-9dfc-bfc4ec0996e6
/
polardbxengine
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
polardbxengine/mysql-test/suite/jp/r/jp_charset_sjis.result

194 lines
8.0 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

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;
Warnings:
Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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))
utf8
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
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 New Issue View Git Blame Copy Permalink