Re: Image in postgresql 7.3
От | Frank Finner |
---|---|
Тема | Re: Image in postgresql 7.3 |
Дата | |
Msg-id | 20060118155953.141d51c9.postgresql@finner.de обсуждение исходный текст |
Ответ на | Image in postgresql 7.3 ("Peerri (sent by Nabble.com)" <lists@nabble.com>) |
Список | pgsql-general |
Hi, like Berend, I also store my PDFs in text columns, but I usually use base64 encoding. AFAICS this has the big advantage versusBLOBs that I do not need to care about backup issues. The disadvantage of course is a bigger database (encoding inflatesabout 30%), so if you have lots and lots of pictures, you might want to use an other method. Another (small) disadvantageis 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@nabble.com> thought long, then sat down andwrote: > > 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@invenius.de Telefax: 0271 231 8608 Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
Вложения
В списке pgsql-general по дате отправления: