JSON issues with dbForge Studio MySQL

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Requnix
Posts: 27
Joined: Thu 12 Dec 2019 19:41

JSON issues with dbForge Studio MySQL

Post by Requnix » Fri 03 Jan 2020 21:10

It appears dbForge Studio MySQL does NOT like JSON fields.

If I set a stored procedure field to type of JSON, whenever I try to debug the stored procedure, I get the error:

Cannot create a JSON value from a string with CHARACTER SET 'binary'.

Note this ONLY happens when trying to debug a Stored Procedure with the Studio debug interface, as seen below. Note the JSON data type is selected:

Image

To fix it? I just change in_JSON to a TEXT type. It's also important to note the EDIT PARAMETERS dialogue doesn't have a JSON data type selectable, only TEXT.

Another issue is the JSON processed with the debugger is tossing a ton of \ in the values, as seen below:

Image

Note entries 13 and above are created by my system; 14, 15 and 16 are from the debugger.

alexa
Devart Team
Posts: 2881
Joined: Fri 24 Jun 2011 14:17

Re: JSON issues with dbForge Studio MySQL

Post by alexa » Mon 06 Jan 2020 15:58

This is to be supported in one of the next product versions.

Requnix
Posts: 27
Joined: Thu 12 Dec 2019 19:41

Re: JSON issues with dbForge Studio MySQL

Post by Requnix » Mon 06 Jan 2020 17:24

Thank you for the clarification. Are we talking about the next few weeks, or are we looking at months until the fix is released?

alexa
Devart Team
Posts: 2881
Joined: Fri 24 Jun 2011 14:17

Re: JSON issues with dbForge Studio MySQL

Post by alexa » Tue 07 Jan 2020 14:28

Unfortunately, we don't have the estimated date for this at the moment.

Requnix
Posts: 27
Joined: Thu 12 Dec 2019 19:41

Re: JSON issues with dbForge Studio MySQL

Post by Requnix » Wed 11 Mar 2020 22:11

Can I please get a status update on this issue? This problem is how hindering the debugging of a commercial application since it will not allow complex JSON content (simple, yes, but not long/complex), which renders the debugger useless.

alexa
Devart Team
Posts: 2881
Joined: Fri 24 Jun 2011 14:17

Re: JSON issues with dbForge Studio MySQL

Post by alexa » Mon 16 Mar 2020 18:25

The new product build with the fix should be released at the end of April.

Requnix
Posts: 27
Joined: Thu 12 Dec 2019 19:41

Re: JSON issues with dbForge Studio MySQL

Post by Requnix » Mon 16 Mar 2020 18:33

Thank you - that makes me VERY happy!

Post Reply