MySQL Bugs: #97374: Deprecate and Remove sjis/ujis character set.

Bug #97374	Deprecate and Remove sjis/ujis character set.
Submitted:	25 Oct 2019 5:24	Modified:	25 Oct 2019 6:06
Reporter:	Meiji Kimura	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S3 (Non-critical)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
sjis and ujis are old character set. They have successors as belows.

sjis -> cp932
ujis -> eucjpms

sjis and ujis cannot translate from/to utf8, so it often cause Garbled string.

And cp932/eucjpms can all characters of sjis/ujis, so It's time to remove from modern MySQL implementation.

Recently there is some bug in sjis only, so it's difficult to continue to support old charactersets in the future.

https://bugs.mysql.com/bug.php?id=62307

How to repeat:
N/A

Suggested fix:
Deprecate sjis/ujis in MySQL 8.0.x, and Remove in the future release.

> And cp932/eucjpms can deal with all characters of sjis/ujis, so It's time to remove from modern MySQL implementation.

Seven character has difference code for sjis/cp932. See details as below (written in Japanse).

https://tmtms.hatenablog.com/entry/201805/mysql-sjis-cp932

and have some comversion problem.

https://dev.mysql.com/doc/refman/5.6/en/faqs-cjk.html#faq-cjk-what-japanese-chars-fail

Hello Meiji-San,

Thank you for the report and feedback.

regards,
Umesh