Why is my Database text field truncated

Started by PxPlus, June 21, 2018, 02:48:40 PM

Previous topic - Next topic

PxPlus

When PxPlus access an external data using the ODBC, MySql, Oracle, ADO, or DB2 interface it needs to set aside a buffer into which the records returned to the program will be build.  This internal buffer will be allocated during the open based on the total length of the data fields in the table.

When referencing text fields, such as CHAR of VARCHAR, the database interfaces set a default text field maximum of 8192 characters.  You can change this by specifying TEXTMAX=nnnn as an option in the OPEN directive. 

Note: This default can also be set in the PxPlus INI in the respective database definition section: [ODBC], [MYSQL], [OCI], [ADO], and [DB2]