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

• 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

SAP IQ 16.0 SP08 PL20 and later

garbage, corrupted,format bcp , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed