DATA TYPES MAPPING FROM ORACLE TO HANA
Find below default mapping from supported ORACLE data types to HANA DATA types:
ORACLE DATA TYPE
SAP (SLT) DATA TYPE
HANA DATA TYPE
VARCHAR2
CHAR
NVARCHAR
CHAR
CHAR
NVARCHAR
NVARCHAR2
CHAR
NVARCHAR
NCHAR
CHAR
NVARCHAR
LONG
STRG
NCLOB
CLOB
STRG
NCLOB
DATE
CHAR
NVARCHAR(9)
*with note 1754547, length 21
TIMESTAMP
CHAR
NVARCHAR (40)
RAW
RAW
BLOB
LONG RAW
RSTR
BLOB
BLOB
RSTR
BLOB
NUMBER (p=0 or p>31, s=0)
FLTP
DOUBLE
NUMBER (0<p<=4, s=0)
INT2
SMALLINT
NUMBER (4<p<=9, s=0)
INT4
INTEGER
NUMBER (9<p<=31, s=0)
DEC
DECIMAL
NUMBER (p<=31, 0<s<=14)
DEC
DECIMAL
NUMBER(all others)
FLTP
DOUBLE
FLOAT
FLTP
DOUBLE
*p - precision
*s - scale

別紙4

Databases on the Web - Georgia State University

Order Type and Validity Overview