Text field truncated using ADO/ODBC?

From: Bill <pg(at)dbginc(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Text field truncated using ADO/ODBC?
Date: 2008-08-21 22:09:13
Message-ID: 48ADE789.3070200@dbginc.com
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. I have a table the contains a Varchar(80)
column and a Text column as well as a couple of integer and datetime
columns. My connection string contains TextAsLongVarchar=1 and
MaxLongVarcharSize=65536, however, my Text column is being truncated at
254 bytes (the value of MaxVarcharSize).

Adding UnknownAsLongVarchar=1 to the connection string causes ADO to see
Text column as LongVarchar and return its complete value but it also
causes the Varchar column to be seen as LongVarChar. This suggests that
the driver sees both Text and Varchar as unknown types.

What must I do to get the ODBC driver to see the Text column as
LongVarchar and the Varchar column as Varchar? The complete connection
string follows by signature.

Thanks.

Bill

Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL
ANSI};DATABASE=app;SERVER=localhost;PORT=5432;UID=postgres;PWD=*;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=2048;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1"

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2008-08-21 22:38:15 Re: [GENERAL] Surprising syntax error
Previous Message Andrew Maclean 2008-08-21 22:04:51 Re: Single character bitfields