Symptom
- 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.
Read more...
Environment
- 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)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7
Keywords
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.