SAP Knowledge Base Article - Preview

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

Symptom

  • Create a virtual table from a remote source created using OracleLogreaderAdapter, 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_CHARACTERSET      WE8ISO8859P15
    NLS_NCHAR_CHARACTERSET     AL16UTF16
  • There is spaces added at the end of every field if the field length is not the same as length of the column definition
    For example: If you define CHAR(5), but the data you insert is 'DDD', 'DDD  ' with 2 space added at the end of the value


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

sdi, column, size, length, dobule, Oracle, OracleLogReaderAdapter , 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.