jp_reverse_sjis.test

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

--character_set sjis
--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 `俿侾俀`;
--enable_warnings

#
# Test REVERSE() function with Japanese characters in sjis encoding
#

SET NAMES sjis;
SET character_set_database = sjis;

CREATE TABLE `俿侾` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俀` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俁` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿係` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俆` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俇` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俈` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俉` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俋` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾侽` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `俿侾侾` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `俿侾俀` (`俠侾` char(5), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = bdb;

INSERT INTO `俿侾` VALUES ('辈炒