See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of HTTP headers, we're able to let user download the PDFs without having to store a local copy on disk, directly from the database (content-disposition header).
Hope this helps. Kurt Haegeman Mediargus.com
Paul Rigor wrote:
Are you running a web server (or ftp server) as well? Because if you are, then you can upload the files to a separate directory using perl and just store the links to that file into a table in your database...
If you're not running a webserver (or ftp)... then lemme konw if you get a viable suggestion.
HEre's my 2cents. Since mysql is a relational database, it would be difficult to display that particular column/row containing the file (esp, binary). You can use perl (or another converter) to convert the binary file into uue (or other text format)... and then import that... make sure you remove the linefeeds and store information about the column widths of the uue (or other text format) into a table in your database. but geez, if the file is considerably large... like i said, it would put a strain on your server. (unless you have GIGS of ram and extra processing speeeed).
good luck, paul
At 01:49 AM 3/9/2004, Isa Wolt wrote:
Hi,
I would like to save a binary file into a mysql database, for later being able to use the file. I am using a perl interafce. Is this at all possible???
And would it be possible to then read that file from a c++ interface?
would be greatful for any help/advices!
Isa
_________________________________________________________________ Hitta rätt på nätet med MSN Sök http://search.msn.se/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________ Paul Rigor [EMAIL PROTECTED] Go Bruins!
