For the fields that are 50 to 255 I use VARCHAR.
Any fields that are 15,000 I use LONGTEXT (just figuring that it holds more data).
I was wondering what is the maximum characters for TEXT? Should I use LONGTEXT for the fields that are 15,000 or TEXT.
I have looked at the storage requirements on the MySQL documentation and I have found this:
From that I get that TEXT has a maximum storage of 65,535?TEXT[(M)] [CHARACTER SET charset_name] [COLLATE collation_name]
A TEXT column with a maximum length of 65,535 (216 – 1) characters.
An optional length M can be given for this type. If this is done, MySQL creates the column as the smallest TEXT type large enough to hold values M characters long.