>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>
