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;
Hi Darius,
It depends on, what client softwer do you use... For example if you would
like to fill BLOBs from a perl script via DBI, you have to use parameter
binding. Could you give me some details?
Regards,
Peter Szekszardi
PortoLogic Ltd.
Portal building, prime number generating, script hacki
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
C
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.
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi
okie heres a snippet of my php code:
the code below takes a file uploaded from the web with $file as declared filename on
the form.
if ($file_size>0) { //check whether the file is not empty
$data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and
add neccessary quote
y, February 05, 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
>
001 7:48
Subject: Re: Insert into blob
> Check text for special symbols and use " in your query (f.e. ...
> blobfield="text")
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 06, 2001
Check text for special symbols and use " in your query (f.e. ...
blobfield="text")
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 2:14 AM
Subject: Insert into blob
> Hi,
>
> I am having some
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
--
