ctype_sjis.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:2k
- -- source include/have_sjis.inc
- #
- # Tests with the sjis character set
- #
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- set names sjis;
- select 'a' like 'a';
- select 'A' like 'a';
- select 'A' like 'a' collate sjis_bin;
- set @sjis1= _sjis 0xa1a2a3a4a5a6a7a8a9aaabacadaeaf;
- set @sjis2= _sjis 0xb0b1b2b3b4b5b6b7b8b9babbbcbdbebf;
- set @sjis3= _sjis 0xc0c1c2c3c4c5c6c7c8c9cacbcccdcecf;
- set @sjis4= _sjis 0xd0d1d2d3d4d5d6d7d8d9dadbdcdddedf;
- set @utf81= CONVERT(@sjis1 USING utf8);
- set @utf82= CONVERT(@sjis2 USING utf8);
- set @utf83= CONVERT(@sjis3 USING utf8);
- set @utf84= CONVERT(@sjis4 USING utf8);
- select hex(@utf81);
- select hex(@utf82);
- select hex(@utf83);
- select hex(@utf84);
- select hex(CONVERT(@utf81 USING sjis));
- select hex(CONVERT(@utf82 USING sjis));
- select hex(CONVERT(@utf83 USING sjis));
- select hex(CONVERT(@utf84 USING sjis));
- #
- # Allow to insert extra CP932 characters
- # into a SJIS column
- #
- create table t1 (a char(10) character set sjis);
- insert into t1 values (0x878A);
- select hex(a) from t1;
- drop table t1;
- #
- # Bug #6206 ENUMs are not case sensitive even if declared BINARY
- #
- create table t1(c enum(0x9353,0x9373) character set sjis);
- show create table t1;
- insert into t1 values (0x9353);
- insert into t1 values (0x9373);
- select hex(c) from t1;
- drop table t1;
- #
- # Bug #6223 Japanese half-width kana characters get truncated
- #
- SET NAMES sjis;
- CREATE TABLE t1 (
- c char(16) default NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=sjis;
- insert into t1 values(0xb1),(0xb2),(0xb3);
- select hex(c) from t1;
- drop table t1;
- SET collation_connection='sjis_japanese_ci';
- -- source include/ctype_filesort.inc
- -- source include/ctype_innodb_like.inc
- -- source include/ctype_like_escape.inc
- SET collation_connection='sjis_bin';
- -- source include/ctype_filesort.inc
- -- source include/ctype_innodb_like.inc
- -- source include/ctype_like_escape.inc
- # Check parsing of string literals in SJIS with multibyte characters that
- # have an embedded in them. (Bug #8303)
- --character_set sjis
- SET NAMES sjis;
- SELECT HEX('嵅搼丂孿') FROM DUAL;
- # End of 4.1 tests