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

Text field truncated using ADO/ODBC

From: Bill <pg(at)dbginc(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Text field truncated using ADO/ODBC
Date: 2008-08-22 16:16:13
Message-ID: 48AEE64D.3090800@dbginc.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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" 





pgsql-odbc by date

Next:From: Mr. JohnDate: 2008-08-27 06:28:52
Subject: Restore and backup with VFP
Previous:From: Marcin LigorowskiDate: 2008-08-19 18:35:36
Subject: Re: resolution for bug 1010313

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