jp_alter_ucs2.test

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

--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 `忢迯磙忢轥;
--enable_warnings

#
# Test altering table with Japanese characters in ucs2 encoding
#

SET NAMES ujis;
SET character_set_database = ucs2;
SET collation_connection = ucs2_general_ci;

#
# Test InnoDB
#
CREATE TABLE `幈幈幈`(`幏幏幏` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `幉幉幉`(`幑幑幑` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = ucs2 engine=INNODB;
CREATE TABLE `忢輳磔忢輅(`彴