2298296 - ADO.NET: 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 Sybase Software Developer Kit (SDK) 15.7 SP133 and SP136
• SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 SP02 PL02
• 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) , Known Error