Re: inserting binary data into mySQL


Subject: Re: inserting binary data into mySQL
From: Greg Jetter (greg@lazymountain.com)
Date: Sat Aug 03 2002 - 16:11:10 AKDT


On Wednesday 31 July 2002 05:59 pm, Scott Johnson wrote:
> Does anyone have much experience in storing files (mp3, jpg, gif) in a
> mySQL DB?
>
> I keep trying to do this with ASP but not having much luck.
>
> Any help appreciated.
>
> Thanks.
>
>
> ---------
> To unsubscribe, send email to <aklug-request@aklug.org>
> with 'unsubscribe' in the message body.
While you can store ifiles as blobs in the data base a faster and more
effective way is to store the location of the file and refrence it when you
want the file . I do this with image files , store them on the disk and
store their location in a database record column. work like a charm....

Greg

---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.



This archive was generated by hypermail 2a23 : Sat Aug 03 2002 - 16:08:20 AKDT