TYPE for page-size input

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
seodevhead
Forum Regular
Posts: 705
Joined: Sat Oct 08, 2005 8:18 pm
Location: Windermere, FL

TYPE for page-size input

Post 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.
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

TEXT or BLOB would do just fine. :)

There are subtle differences, but mostly work the same.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
seodevhead
Forum Regular
Posts: 705
Joined: Sat Oct 08, 2005 8:18 pm
Location: Windermere, FL

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

TEXT = 64K buffer
MEDIUMTEXT = 16MB buffer
LONGTEXT = 4GB buffer
Post Reply