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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.