I'm working on a system where I'm going to import data from an Excel. Since these data will be temporary, I want to save the information for this imported column in
JSON format in the database.
So, I was in doubt about using
Of course this case is just an example, but there are other cases where the doubt comes in mind, for example, when saving a publication of a blog system in the bank. I would have to use
I imagine it makes a difference just because of the names, not because of technical details of the difference between them.
So my question is:
What is the difference between
LONGTEXTmake my bank use more features than using
Is there a difference in read speed or performance when choosing one or the other?
In what cases would I have to use
NOTE : Actually, I do not even want someone to point out what I should do with these data I'm importing, but I'd just like to know the difference between two types (LONGTEXT and TEXT). Even though I know the new version of MYSQL has the format JSON , but that's another story, since I do not use the new version of MYSQL *.