Check the archives, it has been covered reacently,
but....
assuming something like perl:
$sql=qq{
insert into some_table
(some_blob)
values
( ?)
};
$sth=$dbh->prepare($sql);
$sth->execute( $my_blob);
Regards
M
-----Original Message-----
From: Hector Rosas [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2002 17:52
To: [EMAIL PROTECTED]
Subject: How to store an Image on MySQL
Hi Everybody, I have a problem with MySQL when I try to store image file
on it. I use a Blob field but the info that must be stored there should be
between quotations marks right? Like a string , i mean "GIF89kjflH......
more binary symbols..." but if the image file information have a quotation
in the file the info would get truncate and MySQL will not store it. My
Question is How can I store a Image on MySQL, and I know that is't bettter
to use a path to the image but I can't do this in that way. Any help would
be great Thanks.
Hector.
--
Get your free email from www.linuxmail.org
Powered by Outblaze
---------------------------------------------------------------------
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
