RE: storing PDF files in mysql ?????
thnx jan vat im planning to do NOW is ill store path to the pdf file in the db as i ve been told the files r gonna take a hell lotta space (n i ve planty of them) secondly i ll keep the TEXT of these pdf files in the db for indexing n them compare search keywordz with these n throw out the matching pdf file (no other way i can see about it) third pal if u ve ever worked with these thinggyz i cant figure out how to disabble text selection while im cpnverting word to PDF so that nobdy can copy the files (im using acrobat dissteller for conversion if this helps) thnx a mill toby .. From: Jan Steinman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: storing PDF files in mysql ? Date: Wed, 9 Oct 2002 12:58:33 -0700 From: Sqlcoders.com Programming Dept [EMAIL PROTECTED] 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: storing PDF files in mysql ?????
Hi, The thing I was wondering is whether there is any advantage in saving IMAGES in a database? I have had a little play around with a 50k jpeg file and it appears that if I save it in Blob format, then the filesize of the database increases by 50K as well, and surely converting it from/to a database just add time to the loading of a page, albeit it very minimal, but as I am designing a site which will host huge numbers of photos, this will make a big difference. Any thoughts or advice on this topic will be most appreciated. Regards Alexis -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 09 October 2002 01:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: storing PDF files in mysql ?????
thnx guyz 1) i m tryin to put the pdf file into a blob field but i cant insert it like normal text how shall i go about inserting it 2) i m in the process of converting the word doccuments to pdf got this acrobat disteller n m havin a million probz with that alone like the security issue I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with this thing n wouldnt mind me mailin him/her plz do lemme no guyz plz hlp . thnx a billion toby From: Sqlcoders.com Programming Dept [EMAIL PROTECTED] To: toby z [EMAIL PROTECTED],list mysql [EMAIL PROTECTED] Subject: RE: storing PDF files in mysql ? Date: Tue, 8 Oct 2002 21:47:23 -0600 Toby, If I understand correctly you want to perform two distinct actions: 1. Convert Microsoft Office Word .doc files into .pdf 2. Store those pdf's in MySQL. 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. If you can convert the .doc's into .html files, you might be able to get away with using Adobe's free email converter service. Email the HTML document to [EMAIL PROTECTED], wait an hour or so, and you'll find a pdf version in your inbox. (There's also a [EMAIL PROTECTED] address if you dont want to use html, but I think you wanted to keep formatting). Once you have the document in PDF, it's a relatively trivial action to store the documents in your MySQL database. HTH, William. -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 18:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: toby z [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: R.Dobson [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
Alexis Antonakis wrote: The thing I was wondering is whether there is any advantage in saving IMAGES in a database? None whatsoever unless you can't do remote file access any other way. # SQL: SELECT name FROM images LEFT JOIN table1 ON table1.imageid = images.id; # Program: open(name) off filesystem, or: # IMG SRC=./images/$name ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: storing PDF files in mysql ?????
From: Sqlcoders.com Programming Dept [EMAIL PROTECTED] 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
Hello There are lots of discussions in this regard and the suggestions are always to save your blob somewhere in your hard disk and just store the path. In my case, each of my image is around 1MB but you know, I find it difficult to map the images stored in a particular machine, through a network using Delphi. But storing in the database solves most of the problems and the users can also easily load and retrieve them. But any suggestions from experts in this regard is welcome regards - Original Message - From: "Alexis Antonakis" [EMAIL PROTECTED] To: "list mysql" [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 8:57 PM Subject: RE: storing PDF files in mysql ? Hi, The thing I was wondering is whether there is any advantage in saving IMAGES in a database? I have had a little play around with a 50k jpeg file and it appears that if I save it in Blob format, then the filesize of the database increases by 50K as well, and surely converting it from/to a database just add time to the loading of a page, albeit it very minimal, but as I am designing a site which will host huge numbers of photos, this will make a big difference. Any thoughts or advice on this topic will be most appreciated. Regards Alexis -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 09 October 2002 01:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: ht
Re: storing PDF files in mysql ?????
Hi toby Just replace the .gif with your .pdf. I hope this will work for you. INSERT INTO photo(name , pic, picname) values( 'raman', load_file('e:/mysql/images/Click.gif'),'Click.gif') ; SELECT length(pic) FROM photo WHERE picname = 'Click.gif' ; UPDATE photo SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; SELECT pic FROM photo WHERE name = 'velan' INTO DUMPFILE 'C:/TEMP/pic2.gif' Good Luck - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 9:45 PM Subject: RE: storing PDF files in mysql ? thnx guyz 1) i m tryin to put the pdf file into a blob field but i cant insert it like normal text how shall i go about inserting it 2) i m in the process of converting the word doccuments to pdf got this acrobat disteller n m havin a million probz with that alone like the security issue I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with this thing n wouldnt mind me mailin him/her plz do lemme no guyz plz hlp . thnx a billion toby From: "Sqlcoders.com Programming Dept" [EMAIL PROTECTED] To: "toby z" [EMAIL PROTECTED],"list mysql" [EMAIL PROTECTED] Subject: RE: storing PDF files in mysql ? Date: Tue, 8 Oct 2002 21:47:23 -0600 Toby, If I understand correctly you want to perform two distinct actions: 1. Convert Microsoft Office Word .doc files into .pdf 2. Store those pdf's in MySQL. 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. If you can convert the .doc's into .html files, you might be able to get away with using Adobe's free email converter service. Email the HTML document to [EMAIL PROTECTED], wait an hour or so, and you'll find a pdf version in your inbox. (There's also a [EMAIL PROTECTED] address if you dont want to use html, but I think you wanted to keep formatting). Once you have the document in PDF, it's a relatively trivial action to store the documents in your MySQL database. HTH, William. -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 18:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ri
Re: storing PDF files in mysql ?????
hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: R.Dobson [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: storing PDF files in mysql ?????
Toby, If I understand correctly you want to perform two distinct actions: 1. Convert Microsoft Office Word .doc files into .pdf 2. Store those pdf's in MySQL. 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. If you can convert the .doc's into .html files, you might be able to get away with using Adobe's free email converter service. Email the HTML document to [EMAIL PROTECTED], wait an hour or so, and you'll find a pdf version in your inbox. (There's also a [EMAIL PROTECTED] address if you dont want to use html, but I think you wanted to keep formatting). Once you have the document in PDF, it's a relatively trivial action to store the documents in your MySQL database. HTH, William. -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 18:20 To: toby z Cc: list mysql Subject: Re: storing PDF files in mysql ? I think if you decide to store in the blob, whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. While you need to display it back, just convert them back to whatever format you like. Else there is always the choice of just storing the path in your database. By the way, which language you are using to write your applications. If it is delphi, I can send you some sample code regards - Original Message - From: "toby z" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 1:14 AM Subject: Re: storing PDF files in mysql ? thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: "R.Dobson" [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php