diff options
| author | unknown <bar@mysql.com> | 2004-10-21 12:17:59 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-10-21 12:17:59 +0500 |
| commit | 8f8236008193394ea2785c0095adf02839cde83a (patch) | |
| tree | da7ea10d906d7cb39018bfc8fe3fc10f160850d1 /mysql-test | |
| parent | ffd77c4679615ba3e4dd7614dadc735af5d4aa9c (diff) | |
| download | mariadb-git-8f8236008193394ea2785c0095adf02839cde83a.tar.gz | |
Allow cp932 characters to be stored in a SJIS column
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ctype_sjis.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/ctype_sjis.test | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_sjis.result b/mysql-test/r/ctype_sjis.result index 1e3e28784a5..26a45dd28e8 100644 --- a/mysql-test/r/ctype_sjis.result +++ b/mysql-test/r/ctype_sjis.result @@ -41,3 +41,9 @@ C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF select hex(CONVERT(@utf84 USING sjis)); hex(CONVERT(@utf84 USING sjis)) D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF +create table t1 (a char(10) character set sjis); +insert into t1 values (0x878A); +select hex(a) from t1; +hex(a) +878A +drop table t1; diff --git a/mysql-test/t/ctype_sjis.test b/mysql-test/t/ctype_sjis.test index 1dd363c4910..68f4f7010e0 100644 --- a/mysql-test/t/ctype_sjis.test +++ b/mysql-test/t/ctype_sjis.test @@ -32,3 +32,12 @@ 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; |