2312290 - Loading iso-1 data file into utf8 collation database results in conversion errors | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

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

Product

SAP IQ 16.0

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

Search for additional results

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