What data format in sql is needed to store json in its entirety?

Question

MySQL

What data format in sql is needed to store json in its entirety?

Answer 1

text, longtext, blob
UPD This is if you agree with the restriction that you read and overwrite this json in its entirety.
If you want to work with it as a data structure, you will either have to use, for example, postgresql where there is actually a json data type, or some nosql solutions.

Answer 2

First, is it really necessary to store Json?
Secondly, what is supposed to be done with this data set.
Well, accordingly, Json is a machine-readable data format and, accordingly, it is better to shove it into a BLOB (binary storage).

Answer 3

You can look at non-jsonb in postgresql www.postgresql.org/docs/9.4/static/datatype-json.html if you need to index json fields