Thread: ODBC and bytea

ODBC and bytea

From
Andreas Lubensky
Date:
Hi,
currently we are trying to integrate Postgres with ODBC and have problems with
blobs.
We tried to use bytea and were under the impression that bytea would act like
a blob in other databases when used through ODBC.
So far we could not make it work properly. It seems we still have to do the
encoding/decoding of the binary data to bytea ourselves. Is this the correct
behavior? I guess we are not the only ones using ODBC and trying to store
blobs in Postgres. But nevertheless there is nearly no information on this
subject to be found.
Any help appreciated :-)