SAP Knowledge Base Article - Preview

2225602 - How does Data Services take NVARCHAR data type when using SAP Sybase ASE as source or target into the repository?

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.