Source language: Translate to:

Add images to Database

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Add images to Database

Postby smartmedia » Wed Apr 15, 2009 11:36 am

Hi..

I wonder if is possible to add an image to a MS Access database blob field using dbpExecSQL command.
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby Neosoft Support » Wed Apr 15, 2009 3:05 pm

You might be able to do it with SQL only if you can convert the image data to binary/hex format. Then, theoretically, you could do something like this:

INSERT INTO mytable (picture) VALUES( 'C9CBBBCCCEB9C8CABCCCCEB9C9CBBB...' )
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby dpayer » Thu Apr 16, 2009 6:15 am

Neosoft Support wrote:You might be able to do it with SQL only if you can convert the image data to binary/hex format. Then, theoretically, you could do something like this:

INSERT INTO mytable (picture) VALUES( 'C9CBBBCCCEB9C8CABCCCCEB9C9CBBB...' )


OR

Mime encode the file. It will be standardized text at that point ( a bit larger than the original file ) and then decode when retrieved.

Hans-Peter's utility can do that.

David P
User avatar
dpayer
 
Posts: 1384
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests

cron