From: Jan Steinman Date: October 9 2002 7:58pm Subject: RE: storing PDF files in mysql ????? List-Archive: http://lists.mysql.com/mysql/121778 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: "Sqlcoders.com Programming Dept" > >You should look into (via google.com) some doc to pdf converters. An example >is this com object: http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy, >it costs $219 and converts .doc to .pdf. That's $219 saved if you're on MacOS X, since PDF conversion is universally available to any application that can print. >Once you have the document in PDF, it's a relatively trivial action to store >the documents in your MySQL database. Using BLOBs, I assume? I believe the original quester also wanted to be able to search them, which I believe is non-trivial! You can't simply slap a FULLTEXT index on them, right? It seems to me one would have to create an index BEFORE putting the PDFs in MySQL, then add that index as a separate FULLTEXT field. ---- SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL ---- -- : Jan Steinman -- nature photography: : Bytesmiths -- artists' services: : Join the forums at