Re: Json in mysql = what type in java?
Posted by: Filipe Silva
Date: October 28, 2017 03:40AM

Connector/J handles JSON data as plain strings. Currently, you have to use some external JSON parser to translate such values into objects.

You can work your JSON structures in your queries, using the supported functions/operators (https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html), but in the end you can only get and set strings trough the connector.

See also, https://dev.mysql.com/doc/refman/5.7/en/json.html for additional information on JSON support in MySQL.

Options: ReplyQuote


Subject
Written By
Posted
October 27, 2017 02:40AM
Re: Json in mysql = what type in java?
October 28, 2017 03:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.