Posted by Jonathan N. Little on 10/10/00 11:45

davemitc@gmail.com wrote:
> btw- your answer was poor quality, be sure to research the question
> before responding to the network next time. ok?
>

Actually it was of very good quality because you could have found your
answer there if you view it.

The given URL

http://dev.mysql.com/doc/refman/5.1/en/data-types.html

explains the different data types where you could have learned that:

"The four BLOB types are TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB.
These differ only in the maximum length of the values they can hold. The
four TEXT types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These
correspond to the four BLOB types and have the same maximum lengths and
storage requirements. See Section 11.5, “Data Type Storage Requirements”."

And if you when to referenced link, Section 11.5

http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html

You would have discovered *exactly* what you wanted to know:

<your question 'that you did not properly quote in your response'>

If I use a MySQL longtext to receive data from a <TEXTAREA> via FORM
POST - how many characters can I transmit before it poofs out?
Similarly, how much for medium and tinytext? Thank you for helping me
understand this.

</your question>

The storage limits, i.e., maximum number of characters each data type
can handle.

You're welcome. And learn to quote when you use Usenet.

--
Take care,

Jonathan
-------------------
LITTLE WORKS STUDIO
http://www.LittleWorksStudio.com

[Back to original message]