Page 1 of 1

TYPE for page-size input

Posted: Sat Oct 22, 2005 1:32 pm
by seodevhead
Hey guys, I'm new to MySQL and was wondering what the best variable type is to use for a variable that will hold about a page worth of user input (text). In other words, this variable will hold a one-page essay that my users will type in to the form. Is MEDIUMTEXT the one I want to use?...unsigned??? Thanks for your help.

Posted: Sat Oct 22, 2005 3:19 pm
by s.dot
TEXT or BLOB would do just fine. :)

There are subtle differences, but mostly work the same.

Posted: Sat Oct 22, 2005 3:20 pm
by seodevhead
scrotaye wrote:TEXT or BLOB would do just fine. :)

There are subtle differences, but mostly work the same.
I think I am going to use the TEXT type. Would it be okay to use MEDIUMTEXT for about a page-length essay input??? Thanks.

Posted: Sat Oct 22, 2005 3:54 pm
by feyd
TEXT = 64K buffer
MEDIUMTEXT = 16MB buffer
LONGTEXT = 4GB buffer