At 12:49 PM -0400 6/5/01, Danny Katcher wrote:
>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.
Use placeholders or quote(). Don't insert the value directly into your
query. (I assume you're using DBI.)
>
>
>
>>>> "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.
--
Paul DuBois, paul@stripped
