SAP Knowledge Base Article - Preview

2592002 - Issues reading blob value


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 [01004] [SAP][ODBC Driver][SQL Anywhere]Value truncated (101)

  DIAG [01004] [SAP][ODBC Driver]Data truncated (0)



SAP SQL Anywhere (any supported versions)
.NET ODBC application


SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0


Sybase , KBA , BC-SYB-SQA-CLI , SQL Anywhere - Client libraries (odbc, jdbc ...) , Problem

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.