MySQL Bugs: #84680: json_quote and json_unquote are wrong for multibyte charsets

Bug #84680	json_quote and json_unquote are wrong for multibyte charsets
Submitted:	26 Jan 2017 9:45	Modified:	1 Feb 2017 9:35
Reporter:	Tor Didriksen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: JSON	Severity:	S3 (Non-critical)
Version:	8.0.1	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The tests for Bug#21193273 git wrong results for utf8mb4

How to repeat:
Change default character set, and run json_functions_innodb.test

Suggested fix:
Use max_char_length() rather than max_length in resolve_type()

Documented fix in the MySQL 8.0.1 changelog, as follows:

        The JSON_QUOTE and JSON_UNQUOTE functions did not work correctly
        with multibyte character sets such as utf8mb4.

Closed.