Search Postgresql Archives

Text field truncated using ADO/ODBC?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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"





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux