The only two considerations I can think of to choose one type of TEXT column over another would be:
1: The added storage required by a LONGTEXT over a TINYTEXT is only 3 bytes per row. Compared to the anticipated average size of the data, this would be neglibible. 2: If you want to impose somewhat of an upper limit on the amount of space used by one resume, you *could* use a specific text type to do so. However, I don't see a good reason to use a TINYTEXT where a varchar(255) should be fine, and I believe practical considerations would kick in for anything beyond TEXT (max 65535). So I'd probably go with the LONGTEXT, too. HTH, Tore. ----- Original Message ----- From: "Tom Ray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 11:28 AM Subject: Column Type help > Hey there, I'm kinda new to using mysql to its full potential and I was > wondering something. I want to store resume information, but I just want > the user to cut and paste the resume in the "Resume" field and then store > all that in one column in the table. Which table type should I use for > this? Longtext? > > TIA > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
