I thought there would be an error message or warning from MySQL in the case that the text you submit is greater than the allowed limit based on the field.
So essentially I submitted text that was about 120,000 characters long, whereas the limit of TEXT is just 65,535 characters! I almost lost half of my data/what I typed without knowing it!
I just altered the field type in my database from TEXT to LONGTEXT. I can't see how LONGTEXT wouldn't be long enough for MOST users and uses, which is basically 400 Million characters long.
Or if you want the middle ground choose MEDIUMTEXT at a length of 16 Million characters.
This is really something not to overlook, especially if you are entering a lot of text/copying and pasting server logs etc..
A BLOB or TEXT column with a maximum length of 255 (2^8 - 1) characters
A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters
A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters
A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters
mysql, text, length, reminder, truncate, submit, essentially, submitted, characters, whereas, typed, altered, database, longtext, wouldn, users, mediumtext, overlook, copying, pasting, server, logs, etc, fields, tinytext, blob, column, maximum,