Re: corrupt pdfs

At 6:26 PM -0500 5/31/06, Richard Lynch wrote: >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" Yes, I was wondering that myself considering the onslaught of "no-no's" one gets by suggesting placing images into a dB. A PDf file is really not that much different and probably better served via file system. tedd -- ------------------------------------------------------------------------------------ http://sperling.com http://ancientstones.com http://earthstones.com