Which release of PostgreSQL? There were numerous changes in BLOB support
from 7.0 to 7.1 to 7.2, your answer depends on the target release of
PostgreSQL.
Benoit Menendez wrote:
> I use both ODBC and JDBC to access the same database (from two different
> applications) and I need blob support...
>
>
>
> I have created and used the "lo" type which is handled correctly by the
> ODBC driver...
>
>
>
> But JDBC does not like the "lo" type for blobs...
>
>
>
> If I do a getBytes on an "lo" I only get 4 (+1) bytes...
>
>
>
> I tried "bytea" but ODBC does not work properly with this type...
>
>
>
> Is the "lo" type supported in a recent patch?
>
>
>
> Thanks,
>
>
>
> Benoit
>