Ang,
Thursday, April 04, 2002, 4:21:10 PM, you wrote:
AHK> Is MySQL capable of storing files (*.doc *.zip etc)? If YES,
AHK> - is there a limit to the size?
AHK> - what is the data type to use? BLOB?
Yes, you should use BLOB types (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB).
You can read about
Try to browse the database of this list, there was a huge conversation on
that about 6-7 month ago.
--
The way I see it, if you declare something portable, you'll always be
wrong, and if you declare it non-portable, you'll always be right. :-)
-- Larry Wall in <[EMAIL PROTECTE
Please discuss the pros and cons of storing a file and its meta data in the
database vs file in the filesystem and the metadata in the database.
File + Metadata in DB
1. Can participate in transaction.
2. Does not get out of sync.
3. Overhead of fetching the file.
File in Filesystem and Metadata
