On Sat, Jan 26, 2002 at 08:11:12PM +0000, Paul Reilly wrote: > > Hi MySQLers, > > What's the best data type to use for a text field of say 500 words > (~5000 chars)? Can I use VARCHAR(5000) or should I use TEXT or > MEDIUMTEXT? > > Also whats the best column type for a binary upload of an image or word > document of say a max 3 MB in size? Should this be a BLOB, MEDIUMBLOB, > LONGBLOB?
Have a look at this part of the MySQL manual: http://www.mysql.com/doc/S/t/Storage_requirements.html and pick the size that best fits your needs. > Are there any good tutorials on the web re: storing large binary > files in MySQL ? So far I've only done simple text, integer > databases. This is covered "MySQL and Perl for the Web" by Paul DuBois. There are a lot of good techniques covered in that book. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 23 days, processed 538,990,175 queries (261/sec. avg) --------------------------------------------------------------------- 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