We have a table which has a column of type long binary. This contains blob data. We have written a stored procedure to read this column value and send it as an output variable (type long binary) to the calling application. The calling application is written in .NET C#. The variable is collected as an ODBC parameter and stored as a byte array.
What we observed is that the complete content is not written to the byte array (ODBC Type varbinary).
The ODBC trace file shows the following error:
DIAG  [SAP][ODBC Driver][SQL Anywhere]Value truncated (101)
DIAG  [SAP][ODBC Driver]Data truncated (0)
SAP SQL Anywhere (any supported versions)
.NET ODBC application
Sybase , KBA , BC-SYB-SQA-CLI , SQL Anywhere - Client libraries (odbc, jdbc ...) , Problem
About this pageThis 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.