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@xxxxxxxxxx> 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.finner@xxxxxxxxxxx Telefax: 0271 231 8608 Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
Attachment:
pgpgbFx5CxVyA.pgp
Description: PGP signature