I have many posts and I find many different answers.
Starting MYSQL 5.7, I have a large JSON object that does not need a query that just stores. Use JSONseems inefficient - I don't need to check it. What is the best solution in this case? BLOBor TEXT- the obvious choice, but what is the best choice of the two?
JSON
BLOB
TEXT
Binary needs to be converted back to text (how is it best for you to do it? PHP or during SQL query?) Wilst text should be returned. I would really appreciate any clarification ...
What does the manual do about JSON type?
. JSON, JSON, , . JSON . .
. , , JSON, . , BLOB TEXT , , , TEXT JSON.
, JSON .., , TEXT BLOB, , , , .
JSON . - JSON , 3,5 BLOB, ?
Source: https://habr.com/ru/post/1664044/More articles:Angular2 No directive with "exportAs" set to "ngModel" Karma / Jasmine - angularhttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1664040/firefox-desktop-notifications-not-showing-when-multiple-tabs-are-open&usg=ALkJrhgeTuwlT9Nldp4wcM-JBPq5d7cP5QIncluding const_iterator in an iterator and defining std :: set - c ++SignalR 2 - Waiting for AJX requests after opening multiple tabs - ajaxHow to set wheels in setup.py - pythonWhy is there no `use std :: io`? - rust"Missing" secret_key_base "for" production "environment" error on Heroku - ruby-on-railsMonth subtracts month - pythonApache ZooKeeper Web Interface - hadoopPrivate class extension in Java - javaAll Articles