how can in insert i.e. a tar-archive in a blob ?
i want to do it with perl. i read allready about the quote function but i
wount work
#!/usr/bin/perl
use DBI;
# DB-Vars
$host = ux4;
$database = db_webera;
$user = webera;
$pass = webera;
$port = 3306;
$driver = mysql;
$dsn =
WA how can in insert i.e. a tar-archive in a blob ?
WA i want to do it with perl. i read allready about the quote function but i
WA wount work
Try to use placholders. I'm under impression that quote is not
reliable. At least man DBI says:
Quote will probably not be able to deal with
WA thank you !
WA i get it into the database but
WA with a select i get
WA select * from table;
WA [..skip..]
WA Can i read the data out and put in a file ?
WA you understand ?
It probably just means that mysql client is confused by binary
data. It usually doesn't handle it well. It doesn't
Hi Darius,
Just an idea: can you cut the binary data into separate small(er) chuncks
and then store it in different records? (Using some identifier to know
which chunks belong together, what is their order,...) This may make data
handling harder, but you can reduce the memory load of the server;
On 3/29/01 3:37 AM, "Darius Ivanauskas" [EMAIL PROTECTED] wrote:
Hello,
Does anybody know, how to insert large amount of data
(ex.: large binary files) into BLOB columns?
Thanks,
Darius Ivanauskas
P.S. Please reply to me.
The general algorithm is:
Open binary file
Check
, 2001 6:15 PM
To: [EMAIL PROTECTED]
Subject: Insert into blob
Hi,
I am having some problems inserting data into a blob field,
everything works
fine but if I use any HTML and try to insert it, it doesn`t work.
So in short
is there something I should be doing to allow HTML to go
Hi,
I am having some problems inserting data into a blob field, everything works
fine but if I use any HTML and try to insert it, it doesn`t work. So in short
is there something I should be doing to allow HTML to go into a text blob? I
am using PHP if that helps.
TIA
Ade
There's a function in php that allows you to escape strings before it is
submitted to mysql. Check it out in the PHP manual.
- Original Message -
From: "Rus" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 7:48
Subject: Re: Insert