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