Description:
When I convert U+00A5 YEN SIGN to ujis:
in earlier versions, result was 0x20,
in current version, result is 0x8E5C,
the correct result is 0x3f.
When I convert U+203E OVERLINE to ujis:
in earlier versions, result was 0x20,
in current version, result is 0x8E7E,
the correct result is 0x3f.
How to repeat:
mysql> create table tuj (ucs2 char(1) character set ucs2,
-> ujis char(1) character set ujis);
Query OK, 0 rows affected (0.23 sec)
mysql> insert into tuj (ucs2) values (0xffe4); /* FULLWIDTH BROKEN BAR */
Query OK, 1 row affected (0.38 sec)
mysql> insert into tuj (ucs2) values (0x00a5); /* YEN SIGN */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0x203e); /* OVERLINE */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0x2014); /* EM DASH */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0xff3c); /* FULLWIDTH REVERSE SOLIDUS */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0xff5e); /* FULLWIDTH TILDE */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0x2225); /* PARALLEL TO */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0xff0d); /* FULLWIDTH HYPHEN-MINUS */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0xffe0); /* FULLWIDTH CENT SIGN */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0xffe1); /* FULLWIDTH POUND SIGN */
Query OK, 1 row affected (0.00 sec)
mysql> insert into tuj (ucs2) values (0xffe2); /* FULLWIDTH NOT SIGN */
Query OK, 1 row affected (0.00 sec)
mysql> update tuj set ujis = ucs2;
Query OK, 11 rows affected, 9 warnings (0.07 sec)
Rows matched: 11 Changed: 11 Warnings: 0
mysql> select hex(ucs2),hex(ujis) from tuj;
+-----------+-----------+
| hex(ucs2) | hex(ujis) |
+-----------+-----------+
| FFE4 | 3F |
| 00A5 | 8E5C |
| 203E | 8E7E |
| 2014 | 3F |
| FF3C | 3F |
| FF5E | 3F |
| 2225 | 3F |
| FF0D | 3F |
| FFE0 | 3F |
| FFE1 | 3F |
| FFE2 | 3F |
+-----------+-----------+
11 rows in set (0.08 sec)
Description: When I convert U+00A5 YEN SIGN to ujis: in earlier versions, result was 0x20, in current version, result is 0x8E5C, the correct result is 0x3f. When I convert U+203E OVERLINE to ujis: in earlier versions, result was 0x20, in current version, result is 0x8E7E, the correct result is 0x3f. How to repeat: mysql> create table tuj (ucs2 char(1) character set ucs2, -> ujis char(1) character set ujis); Query OK, 0 rows affected (0.23 sec) mysql> insert into tuj (ucs2) values (0xffe4); /* FULLWIDTH BROKEN BAR */ Query OK, 1 row affected (0.38 sec) mysql> insert into tuj (ucs2) values (0x00a5); /* YEN SIGN */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0x203e); /* OVERLINE */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0x2014); /* EM DASH */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0xff3c); /* FULLWIDTH REVERSE SOLIDUS */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0xff5e); /* FULLWIDTH TILDE */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0x2225); /* PARALLEL TO */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0xff0d); /* FULLWIDTH HYPHEN-MINUS */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0xffe0); /* FULLWIDTH CENT SIGN */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0xffe1); /* FULLWIDTH POUND SIGN */ Query OK, 1 row affected (0.00 sec) mysql> insert into tuj (ucs2) values (0xffe2); /* FULLWIDTH NOT SIGN */ Query OK, 1 row affected (0.00 sec) mysql> update tuj set ujis = ucs2; Query OK, 11 rows affected, 9 warnings (0.07 sec) Rows matched: 11 Changed: 11 Warnings: 0 mysql> select hex(ucs2),hex(ujis) from tuj; +-----------+-----------+ | hex(ucs2) | hex(ujis) | +-----------+-----------+ | FFE4 | 3F | | 00A5 | 8E5C | | 203E | 8E7E | | 2014 | 3F | | FF3C | 3F | | FF5E | 3F | | 2225 | 3F | | FF0D | 3F | | FFE0 | 3F | | FFE1 | 3F | | FFE2 | 3F | +-----------+-----------+ 11 rows in set (0.08 sec)