SAP Knowledge Base Article - Preview

2312290 - Loading iso-1 data file into utf8 collation database results in conversion errors - SAP IQ

Symptom

Loading iso-1 data file into utf8 collation database results in conversion errors when special characters are being inserted. The error one might receive is similar to
Cannot convert Herv?No to a varchar(100) (column ContactName)
SQLCODE=-157, ODBC 3 State="07006"
File: "load_tab.sql" on line 4, column 1
LOAD TABLE ab1(activity_id, ContactID, ContactName)
...
You can continue executing or stop.
1. Stop
2. Continue


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

Sybase IQ ; conversion error; convert ; insert into ; special characters ; tilde ; accent ; multi-byte character set   , 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.