Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Json Field MySql cannot be loaded


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Mar 28, 2018 11:26 PM Last Post By: Lajos Juhasz Threads: [ Previous | Next ]
Stephen Hahn

Posts: 3
Registered: 1/12/03
Json Field MySql cannot be loaded  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 20, 2018 3:27 PM
I'm trying to load a field of type "JSON" from a MySql database, but get the message:
"overflow of column [test_json] with variable length. valuelength - [4], maxlength of column - [1]"
(translated from german by me, so the english message might differ a bit...)

I found a post where there is stated that JSON-fields are mapped to WideMemo:
[https://forums.embarcadero.com/thread.jspa?threadID=118068]
but in the FDQuery-editor on page "Stucture" it says "AnsiString(1)" for the DataType.

I tried to map to another fieldtype, but with no success.

Can anyone help me on this?
Thanks
Steve
Stephen Hahn

Posts: 3
Registered: 1/12/03
Re: Json Field MySql cannot be loaded  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 28, 2018 1:54 PM   in response to: Stephen Hahn in response to: Stephen Hahn
After a week it seems no one has a solution.
So maybe this is a bug?
Can anyone from Embarcadero confirm this?
Lajos Juhasz

Posts: 801
Registered: 3/14/14
Re: Json Field MySql cannot be loaded  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 28, 2018 11:26 PM   in response to: Stephen Hahn in response to: Stephen Hahn
Stephen Hahn wrote:

After a week it seems no one has a solution.
So maybe this is a bug?
Can anyone from Embarcadero confirm this?

In order to do that open a ticket at https://quality.embarcadero.com.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02