mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
2fdb556e04
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.
173 lines
6.6 KiB
Text
173 lines
6.6 KiB
Text
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 `Ｔ９`;
|
||
SET NAMES utf8;
|
||
SET character_set_database = utf8;
|
||
CREATE TABLE `Ｔ１` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
|
||
CREATE TABLE `Ｔ２` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
|
||
CREATE TABLE `Ｔ３` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
|
||
CREATE TABLE `Ｔ４` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
|
||
CREATE TABLE `Ｔ５` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
|
||
CREATE TABLE `Ｔ６` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
|
||
CREATE TABLE `Ｔ７` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
|
||
CREATE TABLE `Ｔ８` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
|
||
CREATE TABLE `Ｔ９` (`Ｃ１` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
|
||
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 `Ｔ９`;
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ１`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ２`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ３`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ１`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ１`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ１`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ１`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ２`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ２`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ２`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ２`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ３`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ３`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ３`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ３`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ４`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ５`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ６`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ４`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ４`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ４`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ４`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ５`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ５`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ５`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ５`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ６`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ６`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ６`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ６`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ７`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ８`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(`Ｃ１`) FROM `Ｔ９`;
|
||
CHARSET(`Ｃ１`)
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ７`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ７`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ７`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ７`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ８`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ８`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ８`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ８`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING utf8)) FROM `Ｔ９`;
|
||
CHARSET(CONVERT(`Ｃ１` USING utf8))
|
||
utf8mb3
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ucs2)) FROM `Ｔ９`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ucs2))
|
||
ucs2
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING sjis)) FROM `Ｔ９`;
|
||
CHARSET(CONVERT(`Ｃ１` USING sjis))
|
||
sjis
|
||
SELECT DISTINCT CHARSET(CONVERT(`Ｃ１` USING ujis)) FROM `Ｔ９`;
|
||
CHARSET(CONVERT(`Ｃ１` USING ujis))
|
||
ujis
|
||
drop table `Ｔ１`;
|
||
drop table `Ｔ２`;
|
||
drop table `Ｔ３`;
|
||
drop table `Ｔ４`;
|
||
drop table `Ｔ５`;
|
||
drop table `Ｔ６`;
|
||
drop table `Ｔ７`;
|
||
drop table `Ｔ８`;
|
||
drop table `Ｔ９`;
|