Thanks for the help everyone, I'm gonna try the longtext approach and see how that works for me.
-----Original Message----- From: "Tore Bostrup" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Wed, 26 Feb 2003 12:06:34 -0500 Subject: Re: Column Type help > 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 --------------------------------------------------------------------- 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
