Large objects truncated when retrieved - Mailing list pgsql-odbc

From Xavier Le Vourch
Subject Large objects truncated when retrieved
Date
Msg-id 3F7DC445.5050806@brittanysoftware.com
Whole thread Raw
Responses Re: Large objects truncated when retrieved  ("Hiroshi Inoue" <inoue@tpf.co.jp>)
List pgsql-odbc
I'm storing pictures in a table using the lo type definition from the
FAQ. The server version is 7.2.3 and the odbc driver is 7.3.100.

The images are stored correctly and can be retrieved on the server fine
using psql but the odbc driver truncates the objects at 32k+1 on the
retrieve (they were stored correctly though).

I've tried to increase the MaxLongVarChar setting in the datasource
definition or even set it to -4, according to the HOWTO describing the
configuration options but nothing works.

What is the correct way to increase the limit on large objects in the
odbc driver?

Thanks,
Xavier

--
Xavier Le Vourch
Brittany Software, Inc.
<xavier@brittanysoftware.com>

PGP Key: http://brittanysoftware.com/gpg_key.asc






pgsql-odbc by date:

Previous
From: "Amanjit Gill"
Date:
Subject: Re: FUD!! ODBC will not be supported by Microsoft in the future
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: Large objects truncated when retrieved