Symptom
Although source data type is nvarchar and no matter the record is English or Chinese character, in DS, it is taken as varchar, but the length keeps the same.
For example, in ASE, a record is set to NVARCHAR(3), when the record is 3 Chinese characters. In DS mapping, 'source part' will automatically become VARCHAR(9), but in 'Query' and 'Target' part, it will become VARCHAR(3).
Read more...
Environment
- SAP Data Services 4.2
- SAP Sybase ASE
Product
SAP Data Services 4.2
Keywords
char, nchar, SQL Anywhere, Sybase IQ , KBA , EIM-DS-EXE , Job Execution , Problem
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.