Re: Store Image in Access Database
| From: | Manuel Lemos | Date: | Wed, 26 Dec 2001 19:49:00 +0000 |
| Subject: | Re: Store Image in Access Database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-78788@lists.php.net to get a copy of this message | ||
Hello,
Mike Baranski wrote:
>
> Hi, I'm trying to store a binary file in an access database, I'm using an ole
> type, and I think that it's getting inserted OK. My problem is that I don't
> know how to pull it out... How do you select the stuff that's in an ole
> object out of the database and display it, a jpg, for example. I can't even
> get the raw data. I've tried converting it to base 16 and inserting it, but
> I still can't pull it out. I know how to do this in mysql, so posting that
> won't help. I need to know how to do this with access.
If you are using ODBC, you may want to try Metabase because it supports
BLOB fields with any ODBC driver. Metabase is Open Source and is freely
available here.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos