jp_alter_ucs2.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:15k
源码类别:
MySQL数据库
开发平台:
Visual C++
- --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 `忢輳磔忢輅(`彴