How to use VB6 for store image to postgresql?

I guess the fastest way is to:

- create a column of type text. ex. create table foo( myimage text );
- read the contents of your image from file and encode it in base64 using:
http://www.vbforums.com/attachment.php?s=42957f48bac95dd18ca8bffcf7578dcc
<http://www.vbforums.com/attachment.php?s=42957f48bac95dd18ca8bffcf7578dcc&amp;a
ttachmentid=49287&d=1152543402> &attachmentid=49287&d=1152543402
- save the base64 encoded string in the database
I hope this helps.

Regards,
Gevik.

_____

From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Premsun
Choltanwanich
Sent: Tuesday, January 29, 2008 10:28 AM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] How to use VB6 for store image to postgresql?

Dear All,

Have you ever store image to postgresql using VB6? Could you give me an
example?

Thank you,

Premsun

NETsolutions Asia Limited

+66 (2) 237 7247

<http://www.nsasia.co.th&gt; NETsolutions Asia Limited