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.