Re: corrupt pdfs

On Wed, May 31, 2006 3:56 am, Ross wrote: > I have pdfs saved as BLOBs We've been through this a zillion time, so search the archives for the pros and cons. > Is there a file size limit in kb for Blobs and what is it? I believe it depends on compile-time settings, but this is really a MySQL question... It's probably 4 Meg or something. > What size of file can a LONG BLOB accomodate? Probably twice as much as a regular one. > If it is not this any ideas? It seems to fix it though! It will only fix it for PDFs up to the size of a LONG BLOB, whatever that is. The REAL fix, imho, is to stop abusing your database for large file storage, and use the custom highly-optimized large file data storage engine commonly known as the "file system" -- Like Music? http://l-i-e.com/artists.htm