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.
