Home > mailing lists

odbc 8.01.02 8190 bytes limitation - Mailing list pgsql-odbc

From	Michael GUIARD
Subject	odbc 8.01.02 8190 bytes limitation
Date	April 24, 2006 18:11:37
Msg-id	011001c6679d$c15d4740$027ba8c0@NSTMike Whole thread Raw
Responses	Re: odbc 8.01.02 8190 bytes limitation (Ludek Finstrle <luf@pzkagis.cz>)
List	pgsql-odbc

Hi all !

I use PostgreSQL database via ado (win32).

I succeeded in storing/retrieving binary format (bytea) to/from database (I use it for images).

But I am limited to 8190 bytes. Is it a way to disable this limitation ?

I saw that the odbc have a MaxLongVarChar option set to 8190. May be my problem come from this, but how can I update this option using ado ?

I saw many posts about this subject but I did not find the solution - may be I am too blind today ;)

thanks

Mike

From: "Benjamin Krajmalnik"
Date: 21 April 2006, 21:51:15
Subject: Re: Problem inserting with remote views in vfp

From: "Andrew Ng"
Date: 24 April 2006, 18:15:58
Subject: Re: Support for PostgreSQL 8.1.3 stable