Re: large objects and pg 7.3.x with OpenOffice.org - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: large objects and pg 7.3.x with OpenOffice.org
Date
Msg-id 3F44A0A3.8363A1@tpf.co.jp
Whole thread Raw
In response to Re: large objects and pg 7.3.x with OpenOffice.org  (Andre Felipe Machado <andremachado@techforce.com.br>)
Responses Re: large objects and pg 7.3.x with OpenOffice.org
List pgsql-odbc
Andre Felipe Machado wrote:
>
> I guess that openoffice escapes the binary file, in order to to
> pass it by value into a SQL statement, as it is recommended for
> bytea and for mysql BLOBs. But pg odbc driver expects raw binary
> file, not escaped one, for longvarbinary. And postgresql/contrib/lo
> also does expect a file name, not a parsed by value.

The problem I see in the log you sent is

    [ODBC][7485][SQLBindParameter.c][186]
        Entry:
            Statement = 0x81e39b0
            Param Number = 2
            Param Type = 1
            C Type = -2 SQL_C_BINARY
            SQL Type = -2 SQL_C_BINARY

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/

pgsql-odbc by date:

Previous
From: Brad Langhorst
Date:
Subject: missing feature and bug
Next
From: Shachar Shemesh
Date:
Subject: Optimize the function names variable