SAP Knowledge Base Article - Preview

2603826 - Date type data from MSSQL Server with Japanese Collation are wrongly transferred - SAP HANA Smart Data Integration

Symptom

 When using flowgraph to replicate data from MSSQL view to HANA, observed the following errors.

  • Data with 'YYYYMM' format is wrongly replicated. E.g. 201204 -> 2012Ap, 201205 -> 2012Ma
  • Data with 'YYYY' format is cut off. E.g. 2012 -> 201, 2013 -> 201
  • Data with 'MM' format is wrongly replicated. E.g. 04 -> Ap, 05 -> Ma
  • Some data are replicated into question mark
  • Some other wrongly replicated data. E.g. 2012年04月 > 201年Ap月


Read more...

Environment

HANA Server: 1.00.122.09
DP Agent: 1.3.8.1
MSSQL Server2014 with Collation set to Japanese_CI_AS

Product

SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0

Keywords

 garbled, Chinese, JP, CN, double, multi, multiple, byte , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

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.