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: