We are using a server job that reads data using a hashfile and two plug-in; one is DB2 reading a dashDB (IBM Bluemix) database and the other using the ODBC stage reading a Paraccel database.
We are receiving the following warning:
Code: Select all
"The connector does not support data transfer in Unicode format. When reading column OPERATOR, data will be converted to UTF-8 and then converted to Unicode. The conversion to UTF-8 can cause data loss or corruption."
The problem seems to be similar to another post here. Is it possible that the fix is not included in DS 9.1?
I have tried to removed the project default NLS mapping of UTF8; changed the char-varchar to nchar-nvarchar; add the extended Unicode property for char-varchar columns and the warning is still there. Any suggestion is welcome.
Thanks.