Re: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar

From: "Bill" <postgresql(at)dbginc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar
Date: 2008-08-21 02:24:28
Message-ID: g8ijks$1u0c$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Further testing has revealed that adding UnknownAsLongVarchar=1 to the
connection string causes ADO to see TEXT fields as LongVarchar but it
also causes all VARCHAR fields of any size to be seen as LongVarChar.

Why is ADO or the ODBC driver seeing all Varchar and Text fields as
type unknown?

--
.Bill.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Maclean 2008-08-21 02:40:29 Single character bitfields
Previous Message Tom Lane 2008-08-21 02:08:34 Re: function SETOF return type with variable columns?