SAP Knowledge Base Article - Preview

2324233 - When extract data using binary, incorrect data appended to varchar column -- SAP IQ

Symptom

  • When the data was extracted using a binary format and incorrect data was appended to the varchar column.
  • Here is an example of incorrect data. In table test, col2, col3 and col4 are defined as varchar (20).

Souce data:

select * from test
       col1 col2                 col3                 col4
--------------------------------------------------------------------------
          1 abcdefg              123                z

Load the binanay data file extract from test. randon characters can be seen in the table.

select * from test
       col1 col2                 col3                 col4
--------------------------------------------------------------------------
          1 abcdefg              123defg          z23defg

 


Read more...

Environment

SAP IQ 16.0 SP08 PL20 and later

Product

SAP IQ 16.0

Keywords

garbage, corrupted,format bcp , KBA , BC-SYB-IQ , Sybase IQ , 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.