MySQL Bugs: #98419: when we want to create table through jdbc it give error of name "🍏"

Bug #98419	when we want to create table through jdbc it give error of name "🍏"
Submitted:	28 Jan 2020 19:33	Modified:	5 Mar 2020 12:53
Reporter:	rohit kumar	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: C API (client library)	Severity:	S4 (Feature request)
Version:	5.5	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
when we want to create table through jdbc it give error of name "&#127823;" and when it is created by work bench on clicking on name again giving error

How to repeat:
on creating table through jdbc of name &#127823;  it is actually 🍏

on creating table through jdbc of name 🍏

Hi Mr. kumar,

Thank you for your feature request.

However, we need more info in order to consider this request.

First of all, have you tried that command from mysql CLI and if you did, did it work.

If it did not work, have you tried using ANSI quotes. Those are described in our Reference Manual.

Next, you have set your category to C API, while you are mentioning only JDBC, so this makes a confusion.

Last , but not least, 5.5 is not maintained any more, while 5.6 is planned to come into its end-of-life period.

Hence, we need a test case from you for the latest 5.7 or 8.0. Provide us with all commands that you have attempted and did not work on the latest releases of the above  two versions.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".