jp_ps_ujis.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:13k
- --source include/have_ujis.inc
- --disable_warnings
- DROP TABLE IF EXISTS t1;
- DROP TABLE IF EXISTS t2;
- DROP TABLE IF EXISTS t3;
- DROP TABLE IF EXISTS t4;
- --enable_warnings
- #
- # Test Prepares Statement with Japanese character in ujis encoding
- #
- SET NAMES ujis;
- SET character_set_database = ujis;
- ### Test InnoDB ###
- CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = InnoDB;
- CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = InnoDB;
- CREATE TABLE t3(
- `幈` char(1),
- `あ` char(1),
- `忢躟 char(1)
- )DEFAULT CHARSET = ujis ENGINE = InnoDB;
- CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = ujis ENGINE = InnoDB;
- INSERT INTO t1 VALUES ('xxx');
- INSERT INTO t2 VALUES ('幈あ忢