ADO/ODBC returns TEXT fields as Varchar, not LongVarChar

From: "Bill" <postgresql(at)dbginc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar
Date: 2008-08-20 23:34:51
Message-ID: g8i9mr$cb0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am new to PostgreSQL and running 8.3 on Windows. I am connecting
using ADO and the ODBC driver. My connection string contains
TextAsLongVarchar=1 and MaxLongVarcharSize=65536, however, my TEXT
column is truncated at 255 bytes.

What must I do to get ADO to recognize the TEXT field as a LongVarchar?

--
.Bill.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-08-21 01:27:37 Re: WAL archiving to network drive
Previous Message Robert Gobeille 2008-08-20 23:20:53 plpgsql - sorting result set