Re: inserting blob data - Mailing list pgsql-odbc

From Henshall, Stuart - Design & Print
Subject Re: inserting blob data
Date
Msg-id E382B5D8EDE1D6118DBE0008C759BCD6116AE8@WCPEXCHANGE
Whole thread Raw
In response to inserting blob data  ("Bruce Holt" <bj_holt@hotmail.com>)
List pgsql-odbc

Tom Lane wrote:
> "Bruce Holt" <bj_holt@hotmail.com> writes:
>>> Hmm, the 8K limit has been gone for a long time.  You didn't mention
>>> your Postgres server's version, but I'm betting you need to update
>>> either your server or your ODBC driver.  Possibly both.
>
>> PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
>
> And your ODBC driver was up to date too, right?  So much for that
> theory.  How exactly are you trying to store the blob data?  (A code
> snippet would be an appropriate answer, probably.)
>
>                       regards, tom lane
>

Ensure that max LongVarchar is suitably high.
hth,
- Stuart

pgsql-odbc by date:

Previous
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: Can't get more than 255 chars out of memo field in Acc
Next
From: Hiroshi Inoue
Date:
Subject: Re: Problem about Bytea and SQL_C_CHAR