Postgres Pro
Downloads
Home   >   mailing lists

Re: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar - Mailing list pgsql-general

From Bill
Subject Re: ADO/ODBC returns TEXT fields as Varchar, not LongVarChar
Date
Msg-id g8ijks$1u0c$1@news.hub.org
Whole thread Raw
In response to ADO/ODBC returns TEXT fields as Varchar, not LongVarChar  ("Bill" <postgresql@dbginc.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: function SETOF return type with variable columns?
Next
From: "Andrew Maclean"
Date:
Subject: Single character bitfields