Mike,
Thank you very much for responding to my question. Haven't been able to
find much out there. Your article, to which you referred in your response,
was something I have already used to get me as far as I had gotten. I'd
found it in my search for an answer. I found the connection string and
Hi Kevin;
You may want to look at the online article I wrote at
http://www.dynamergy.com/mike/articles/blobaccessvb.html which covers use of
the stream object in detail. While written for VB, it should be easy enough
to convert to ASP.
Mike Hillyer
-Original Message-
From: Kevin Wix
If I remember correctly from the manual, you can dump
your data generating the SQL statements (this is what
you are doing) and your file will have a bunch of
INSERTS. Your problem is that those inserts will have
something like SET YourBinaryField =
'a-bunch-of-characters'. The problem is that some
are you null terminating the string?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sameer Maggon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 7:51 AM
Subject: Binary Data mysql_real_escape_
> Hi,
> Please see the code given below::
>
>
On Fri, 14 Dec 2001, Ian Collins wrote:
>
> I am having difficulties with entering binary data from a c program.
> I have passed the string through mysql_real_escape_string.
Post the C data then. However read on.
>
> . . .
>
> drop table if exists junk5;
>
> create table junk5
> (
> id int no
On Thu, Jul 12, 2001 at 01:51:29AM +0200, Werner Stuerenburg wrote:
>
> Im my understanding, you are storing images. AFAIK, images should
> not be stored in the db but in the filesystem.
There's nothing wrong with doing it, as long as you understand what
you're doing. After all, images are (from
Im my understanding, you are storing images. AFAIK, images should
not be stored in the db but in the filesystem. You store only the
filename and other data (time etc.) in the db. There are some
remarks on this at php.net and other places, as this question is
posed often.
Sie schrieben am Mittwoch
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
On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote:
> I have the scripts in php to do this if u want.
Yes, that would help! thanks.
>
> "Robert C. Paulsen Jr." wrote:
>
> > How can I put binary data into a MySQL database?
> >
> > I assume the data type is blob, but I don't see how I
I have the scripts in php to do this if u want.
"Robert C. Paulsen Jr." wrote:
> How can I put binary data into a MySQL database?
>
> I assume the data type is blob, but I don't see how I can
> use SQL syntax to insert anything but text data. I would
> like to include various binary files (tar f
Hi Barry,
I do not know what do you use for feeding your database, but in Perl you
shoud use the DBI module, and insert the binary data through bindings.
use DBI;
use strict;
...
my $dbh = DBI->connect("dbi:mysql:image_db", "user", "password") || die
"$DBI::errstr\n";
If your using PHP there is an article here on doing it with PHP3, it works
on 4 as well. HTH
http://www.phpbuilder.com/columns/florian19991014.php3
Dave W.
-Original Message-
From: Barry Radloff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 10:56 PM
To: '[EMAIL P
> hi I am pretty new at this and would like to know how does one store a
> binary blob to the mysql DB ie I would like to store a jpeg to the db
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0
http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
/ Carsten
--
Carsten H. Pedersen
keeper and mainta
Barry,
This can be done using normal insert/update statements. You only have to
'escape' the binary zero, the backslash and the quotes (' or ") out;
suppose jpg contains the binary data, the following code will do the trick:
(pseudo code:)
for (i=length(jpg); i--; i>0) {
if (jpg[i] in [#0,
14 matches
Mail list logo
