Does json usually have enclosing quotation marks when stored in a database field?
Which of the following would be correct for the json column?
`json`
'{"Color": "Red"}'
{"Color": "Red"}
My assumption would be the second, but just wanted to make sure that's correct. And if so, why?
As of MySQL 5.7.8, MySQL supports a native JSON data type
If you use earlier version and store it as text, store it without the enclosing quotation marks.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments