Text field truncated using ADO/ODBC?

Поиск
Список
Период
Сортировка
Искать
От
Bill
Тема
Text field truncated using ADO/ODBC?
Дата
Msg-id
48ADE789.3070200@dbginc.com
Список
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-general по дате отправления
От: Ruben Gouveia
Дата:
От: Andrew Maclean
Дата:
Сообщение: Re: Single character bitfields
FAQ