Data type conversion table: Informix to SAP HANA

Table 1. Data type conversion table (Informix to SAP HANA )
Informix® data types SAP HANA ® data types
CHAR(n) NVARCHAR(n) (max is 5000 characters)
VARCHAR(n[,m]) NVARCHAR(n) (max is 5000 characters)
LVARCHAR(n) NVARCHAR(n) (max is 5000 characters)
NCHAR(n) N/A
NVARCHAR(n[,m]) N/A
BOOLEAN BOOLEAN
SMALLINT SMALLINT
INT / INTEGER INTEGER
BIGINT BIGINT
INT8 BIGINT
SERIAL[(start)] INTEGER (see note 1)
BIGSERIAL[(start)] BIGINT (see note 1)
SERIAL8[(start)] BIGINT (see note 1)
DOUBLE PRECISION / FLOAT[(n)] DOUBLE
REAL / SMALLFLOAT REAL
NUMERIC / DEC / DECIMAL(p,s) DECIMAL(p,s)
NUMERIC / DEC / DECIMAL(p<=19) DECIMAL(p*2,p)
NUMERIC / DEC / DECIMAL(p>19) N/A: Max p is 38 for SAP HANA
NUMERIC / DEC / DECIMAL DECIMAL(32,16)
MONEY(p,s) DECIMAL(p,s)
MONEY(p) DECIMAL(p,2)
MONEY DECIMAL(16,2)
DATE DATE
DATETIME HOUR TO MINUTE TIME
DATETIME HOUR TO SECOND TIME
DATETIME YEAR TO MINUTE SECONDDATE
DATETIME YEAR TO SECOND SECONDDATE
DATETIME YEAR TO FRACTION(n) TIMESTAMP
DATETIME q1 TO q2 (different from above) TIMESTAMP
INTERVAL q1 TO q2 VARCHAR(50)
TEXT NCLOB
BYTE CLOB
Notes:
  1. For more details about serial emulation, see SERIAL data types.