Symptom
Upgraded toAdapive Server Enterprise 15 and using the following database parameters in PowerBuilder is causing truncation when data is greater than 255 characters:
DBParm = "Release='15.5,CharSet='roman8'"
Environment
-
SAP Adaptive Server Enterprise 15
-
PowerBuilder
Cause
This issue was caused by using SQLCA.DBMS = "SYC Adaptive Server Enterprise" instead of "ASE Adaptive Server Enterprise".
See "Using Adaptive Server Enterprise" from the "Connecting to Your Database" documentation for an explanation of the SYC and ASE interfaces.
Solution
This issue was resolved by switching to the ASE interface:
SQLCA.DBMS = "ASE Adaptive Server Enterprise" SQLCA.DBParm = "Release='15.5',CharSet='roman8'"
