Re: Column Type help
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
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
Re: Column Type help
I'm actually doing the same thing. I settled on using TEXT, which allows you to store a little over 65,000 bytes. Any resume longer than 65,000 characters really needs to be made shorter since that works out to probably about 20 pages. As an aside, I don't know which version of MySQL you are using, but the full text indexing is very much improved in version 4. On Wednesday, February 26, 2003, at 11:28 AM, Tom Ray wrote: 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 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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
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