List:General Discussion« Previous MessageNext Message »
From:Jan Steinman Date:October 9 2002 7:58pm
Subject:RE: storing PDF files in mysql ?????
View as plain text  
>From: "Sqlcoders.com Programming Dept" <coders@stripped>
>
>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: <http://www.Bytesmiths.com>
: Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services>
: Join the forums at <http://www.Bytesmiths.com/wiki>

Thread
storing PDF files in mysql ?????toby gibbson8 Oct
  • Re: storing PDF files in mysql ?????R.Dobson8 Oct
Re: storing PDF files in mysql ?????toby z8 Oct
  • Re: storing PDF files in mysql ?????kayamboo9 Oct
    • RE: storing PDF files in mysql ?????Sqlcoders.com Programming Dept9 Oct
    • RE: storing PDF files in mysql ?????Alexis Antonakis9 Oct
      • Re: storing PDF files in mysql ?????Michael T. Babcock9 Oct
      • AW: storing PDF files in mysql ?????Kai Zaunick9 Oct
      • Re: storing PDF files in mysql ?????kayamboo10 Oct
RE: storing PDF files in mysql ?????toby z9 Oct
  • Re: storing PDF files in mysql ?????kayamboo10 Oct
RE: storing PDF files in mysql ?????Jan Steinman9 Oct
RE: storing PDF files in mysql ?????toby z10 Oct