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-postg....html#a2446227
Sent from the PostgreSQL - general forum at Nabble.com.

Peerri (sent by Nabble.com) wrote:


> 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.

This may not be for the faint of heart, but what I do is uuencode images
and store them in TEXT type columns. I started doing this because (and
here my memory may not be serving me with clear fidelity) I got the
impression from documentation when I first started using PG several
years ago that there was some "gotcha" related to BLOBs or BYTEA type
columns in the pg_dump/pg_restore process. This approach has worked for
my needs (mugshots and scanned written signatures), and so I never
revisited the implementation.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly