From: | "Gevik Babakhani" <pgdev(at)xs4all(dot)nl> |
---|---|
To: | "'Premsun Choltanwanich'" <Premsun(at)nsasia(dot)co(dot)th>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: How to use VB6 for store image to postgresql? |
Date: | 2008-01-29 11:28:15 |
Message-ID: | 000e01c8626a$0eb90100$0a01a8c0@gevmus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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&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(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Premsun
Choltanwanich
Sent: Tuesday, January 29, 2008 10:28 AM
To: pgsql-hackers(at)postgresql(dot)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> NETsolutions Asia Limited
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-01-29 12:06:05 | Re: RFC: array_agg() per SQL:200n |
Previous Message | Stefan Kaltenbrunner | 2008-01-29 11:26:44 | Re: Proposed patch: synchronized_scanning GUC variable |