3597695 - Migration from Oracle to HANA: CHAR Field Displays Empty String Instead of Space

Symptom

Post migration from Oracle to HANA you encounter a difference between Oracle and HANA.

The HANA table's CHAR field of length 1, differs from what was seen on Oracle.

In this scenario:

HANA contained post migration ‘X` (true) or an empty string `` (false) whereas Oracle would contain a space ` ` (false).

Environment

HANA Platform 2.0

Keywords

Oracle to HANA, single space, empty string, nvarchar, varchar, char, migration, integration, table, field, restriction , KBA , HAN-DB , SAP HANA Database , 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.