Re: Large objects truncated when retrieved

Hiroshi Inoue wrote:

>>-----Original Message-----
>>From: Xavier Le Vourch
>>Sent: Saturday, October 04, 2003 3:48 AM
>>
>>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).
>
>
> Which data type are you using to store the images ?

I'm using the lo type defined in the FAQ at:

http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52

> And what kind of tools are you using ?
> In most cases tools have their own limitations.
>

I'm using Borland C++ 6 but the problem seems to be coming from the
driver as when I enabled logging, I get messages like:

conn=67191248, query='COMMIT'
The 2th item was truncated
The buffer size = 32769 and the value is '1040924'

even when I modified Max LongVarChar in the data source.

If the image size is less than 32769, it works but anything larger than
that will be truncated on the retrieval only.

Best regards,
Xavier

--
Xavier Le Vourch
Brittany Software, Inc.
<xavier(at)brittanysoftware(dot)com>

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