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 TEXT
or LONGTEXT
.
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 TEXT
or LONGTEXT
?
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
LONGTEXT
andTEXT
? -
Would using
LONGTEXT
make my bank use more features than usingTEXT
? -
Is there a difference in read speed or performance when choosing one or the other?
-
In what cases would I have to use
LONGTEXT
instead ofTEXT
?
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 *.