Hello, Hiroshi
Many thanks for your message.
I opened a new issue at openoffice.org describing this behaviour and asking
for some guidance, given your findings in the log.
I tried to use the "bytea as LO" in the psqlodbc, but it does not work too.
An error pops : error inserting the record.
SQL error HY000
Error code 7.
Verifying the db, it shows the ID updated, but not the image.
Please, try yourself to see the details.
For use bytea as lo, is there another set up to execute?
Best regards.
Andre Felipe
>
> OpenOffice is binding SQL_BINARY(SQL_C_BINARY seems a unixODBC's
> bug) SQL Type parameter not an SQL_LONGVARBINARY one. Unfortunately
> I don't understand the reason.
>
> Though I don't love the *bytea* type, you can turn on
> the *bytea as LO* DSN option. *bytea* is only for not
> so large objects.
>
> regards,
> Hiroshi Inoue
> http://www.geocities.jp/inocchichichi/psqlodbc/