SAP Knowledge Base Article - Preview

2807325 - Character column length issue with Oracle data types - SAP HANA Smart Data Integration

Symptom

When  creating a virtual table from a remote source created using OracleLogreader adapter, the char and varchar2 datatype column lengths are doubled. Nchar types are not affected.

Ex: If Oracle has CHAR(6) in HANA Virtual table the data type is VARCHAR(12)

  • HANA characterset is UTF-8
  • NLS_CHARACTERSET      WE8MSWIN1252
  • NLS_NCHAR_CHARACTERSET     AL16UTF16


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

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.