2298296 - ADO.NET Provider Error “String data, right truncated" - SDK for SAP ASE

• ADO.Net Data Provider truncates big strings into 16384 characters (16K) when inserting big strings into an ASE table column of a text data type.
• The issue may happen silently.
• The issue can result in an error “String data, right truncated” in ADO.Net client applications.
• The following pattern can be seen in the RIBO tracing (example using “*” in big string sequence):

PDU Header
 
  TDS Packet Type [1]:          BUF_NORMAL (0x0F)
  Status [1]:                   BUFSTAT_EOM (0x01)
  Length [2]:                   176
  Channel [2]:                  0
  Packet No. [1]:               0
  Window [1]:                   0
 
PARAMS Token (0xD7); variable length.
 
  Param 1
    Length [4]:                 16384
    Param data [16384]:  “*** (...) ***” 

• Using “set textsize” or “TextSize” in the connection string to expand the string size does not work. 

• SAP Adaptive Server Enterprise (SAP) 16.0 SP02 PL02
• SAP Adaptive Server Enterprise (SAP) 15.7
• SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 SP02 PL02
• SAP Sybase Software Developer Kit (SDK) 15.7 SP133 and SP136
• Adaptive Server Enterprise ADO.Net Data Provider
• 4.0 Prover (Sybase.AdoNet4.AseClient.dll)

AseConnection, connstring, adonet, driver, CR796948. CR#796948. 796948, ado,net, text, string truncation , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed