Hello,
Using PB 2022 R2 Build 2819, PostGRESql 15
Need to retrieve string values into a datawindow, whose length varies from 50000 to 100000 characters. Currently it retrieves only 10000 characters with the following settings.
Using DSN-Less connection, [ @ runtime ]
SQLCA.DBParm="ConnectString='Driver=PostgreSQL Unicode(x64);Database=one;Server=localhost;Port=<Port>;UID=<username>;PWD=<pass>;',DisableBind=1"
Design Mode [ Datawindow ]. It shows a length of 32766, with the following settings in DB Profile [ Driver specific parameters ]
MaxVarcharSize=100000;MaxLongVarcharSize=100000;
Still it retrieves only 10000 characters.
Database field got complete value. Only in datawindow we get only 10000 characters, and not the complete value [ which ranges from 50000 - 70000 characters].
What setting we need to do for PB to read full value(s) ?
Happiness Always
BKR Sivaprakash