SAP Knowledge Base Article - Preview

1972981 - Input file of LOAD TABLE must be the same character set as that of the server - SAP IQ

Symptom

  • The LOAD TABLE statement allows efficient mass insertion into a database table from a file with ASCII or binary data.
  • However, if the collation sequence of the IQ server and character set of the input file is different, data is not inserted correctly.
  • Multibyte character that is inserted will be garbled.


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.0
  • SAP IQ 16.1
  • SAP IQ 16.2

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP IQ 16.2 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

SAP IQ, LOAD, collation, garbled, character set, Multibyte , KBA , BC-SYB-IQ , Sybase IQ , How To

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.