Re: Image in postgresql 7.3

Hi,

like Berend, I also store my PDFs in text columns, but I usually use base64 encoding. AFAICS this has the big advantage versus BLOBs that I do not need to care about backup issues. The disadvantage of course is a bigger database (encoding inflates about 30%), so if you have lots and lots of pictures, you might want to use an other method. Another (small) disadvantage is that one has to encode/decode the binary files before storing/after retreiving.

Regards, Frank.

On Wed, 18 Jan 2006 05:13:22 -0800 (PST) "Peerri (sent by Nabble.com)" <lists(at)nabble(dot)com> thought long, then sat down and wrote:

>
> Please help me!!!
> I'm with problems to record images in database in field type bytea.
> I'm using visual basic 6.0 and object ado stream to convert binary.
>
> They say me if another way exists to record the images in the data base.
>
> Thanks!!
> [:-)
> --
> View this message in context: http://www.nabble.com/Image-in-postgresql-7.3-t944227.html#a2446227
> Sent from the PostgreSQL - general forum at Nabble.com.
>

--
Frank Finner

Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606 Mail: frank(dot)finner(at)invenius(dot)de
Telefax: 0271 231 8608 Web: http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651