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
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.