jp_create_tbl_ucs2.test

来自「这个文件是windows mysql源码」· TEST 代码 · 共 32 行

--source include/have_ucs2.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 `えええ`;
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 creating table with Japanese characters in ucs2 encoding
#

SET NAMES ujis;
SET character_set_database = ucs2;

CREATE TABLE `幈幈幈`(`幎幎幎` char(1)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `幉幉幉`(`幏幏幏` char(1)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `忢輳磔忢輅(`彴