Skip site navigation (1) Skip section navigation (2)

TEXT fields with size > 8190

From: "Ing(dot) Ivo Schwarzer" <schwarzer(at)bugnion(dot)it>
To: pgsql-odbc(at)postgresql(dot)org
Subject: TEXT fields with size > 8190
Date: 2001-05-18 08:17:57
Message-ID: 3B04F6D5.7702.2FD1F8@localhost (view raw or flat)
Thread:
Lists: pgsql-odbc
Why am I unable to store long strings using TEXT fields if the size 
of my string is > 8190 chars?

If I try to increase Max LongVarChar to 20000 (in the Advanced 
Options box of the Odbc driver) i get run-time error  -2147467259 
(80004005) in my VisualBasic 6 application (Ado 2.5).
I use Postgres 7.1.1 (RedHat 6.2 RPM version) and the win ODBC 
driver 7.01.00.05 (in the Data Type Option box I have Text as 
longVarChar = true).

Is this a Driver related error or am I wrong trying to use a TEXT field 
to store long strings (< 64k)?

Thanks, Ivo.

pgsql-odbc by date

Next:From: Jorge SantosDate: 2001-05-18 20:50:22
Subject: Postgresql 7.1 + unixODBC 2.0.5 + StarOffice 5.2
Previous:From: Peter WilkinsonDate: 2001-05-17 12:45:09
Subject: Are there any special gotcha's with using cursors with ODBC to postgresql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group