It's my understanding that it's even harder to get it out once you have it
in. Would love to see code of how to display a picture on a web page after
retrieving it from the database.
From what I understand, it's more efficient just to store a pointer (url) to
the picture on your websever in the database.
Shaun
-----Original Message-----
From: Danny Katcher [mailto:DKatcher@stripped]
Sent: Tuesday, June 05, 2001 11:50 AM
To: mark.moline@stripped; win32@stripped
Subject: RE: Storing Pictures or other file types in a MYSQL database
but how do you code it
I have tried a perl statement that loads a binary (gif file ) into a
$variable and then tries to insert this into the database but it chokes on
the binary characters.
>>> "Moline, Mark A." <mark.moline@stripped> 06/01/01 03:54PM
> >>>
You can use the type of blob (binary large object). There are a few
different sizes. The biggest is a 2GB blob.
-----Original Message-----
From: Shaun Gilley [mailto:sgilley@stripped]
Sent: Friday, June 01, 2001 2:02 PM
To: 'win32@stripped'
Subject: Storing Pictures or other file types in a MYSQL database
I want to store images in a MySQL table. Is this possible? What column
type would this be? Isn't this possible in other databases such as Oracle?
Thanks.
Shaun
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread6324@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@stripped instead.
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread6325@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@stripped instead.
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread6347@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@stripped instead.
