Thanks for all the answers!!!
I have been trying the longblob's and it seems to work!
Now all I have to is to figure out how to read it out.. but how hard can it
be ;)
thanks again for all good suggestions!
/isa
From: Kurt Haegeman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Saving file into database
Date: Wed, 10 Mar 2004 14:25:33 +0100
Use the BLOB, Luke!
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 spd).
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!
_
Chatt: Träffa nya nätkompisar på Habbo Hotel
http://habbohotel.msn.se/habbo/sv/channelizer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
