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"