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 PowerBuilder Connecting to Your Database documentation for an explanation of the SYC and ASE interfaces.

Resolution

This issue was resolved by switching to the ASE interface: 

SQLCA.DBMS = "ASE Adaptive Server Enterprise"
SQLCA.DBParm = "Release='15.5',CharSet='roman8'"

0
0