MySQL Bugs: #93568: Cannot create a JSON value from a string with CHARACTER SET 'binary'.

Bug #93568	Cannot create a JSON value from a string with CHARACTER SET 'binary'.
Submitted:	12 Dec 2018 7:54	Modified:	12 Dec 2018 8:17
Reporter:	AMU lin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: JSON	Severity:	S3 (Non-critical)
Version:	5.7.2	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Cannot create a JSON value from a string with CHARACTER SET 'binary'.

Description:
I tried to create an FEDERATED table and included an JSON Column.
But When I Select from this table shows:
ERROR 3144 (22032): Cannot create a JSON value from a string with CHARACTER SET 'binary'.

How to repeat:
Table1:
CREATE TABLE employees (
 	data JSON NOT NULL
);
Table2:
CREATE TABLE employees2 ( data JSON NOT NULL)engine=federated default charset=utf8 connection='mysql://root:234@127.0.0.1:3306/testa/employees';

When I select from Table2
 MySQL  localhost:33060+ ssl  testa  SQL > select * from employees2;
ERROR: 3144: Cannot create a JSON value from a string with CHARACTER SET 'binary'.

Suggested fix:
How to solve it?
I need to use this feature,update mysql?

Hello AMU lin,

Thank you for the report.
This is duplicate of Bug #93052, and reported issue is fixed in upcoming MySQL 8.0.14 version which is not yet GA. 

Quoting closure details from the base Bug #93052.
[27 Nov 12:13] Jon Stephens
Documented fix as follows in the MySQL 8.0.14 changelog:

        When trying to select from a JSON column of a FEDERATED table,
        the server returned ER_INVALID_JSON_PATH_CHARSET -Cannot create
        a JSON value from a string with CHARACTER SET 'binary'-.

        In addition, neither DELETE or UPDATE had any effect on a
        FEDERATED table containing a JSON column.

regards,
Umesh

https://bugs.mysql.com/bug.php?id=93052&thanks=3&notify=195

I've seen the acquaintance answer.  As above。
How to solve it?

But I can't upgrade 8.0.14

and When will 8.0.14 be released?