Data type conversion table: Informix to SAP ASE

Table 1. Data type conversion table (Informix to SAP ASE)
Informix® data types	SAP® ASE data types
`CHAR(n)`	`CHAR(n)` (limit = page size, ex:16384 bytes)
`VARCHAR(n[,m])`	`VARCHAR(n)` (limit = page size, ex:16384 bytes)
`LVARCHAR(n)`	`VARCHAR(n)` (limit = page size, ex:16384 bytes)
`NCHAR(n)`	`NCHAR(n)` (length in characters)
`NVARCHAR(n[,m])`	`NVARCHAR(n)` (length in characters)
`BOOLEAN`	`BIT` (must be NOT NULL!)
`SMALLINT`	`SMALLINT`
`INTEGER`	`INTEGER`
`BIGINT`	`BIGINT`
`INT8`	`BIGINT`
`SERIAL` (without start value!)	`INTEGER` (see note 1)
`BIGSERIAL` (without start value!)	`BIGINT` (see note 1)
`SERIAL8` (without start value!)	`BIGINT` (see note 1)
`DOUBLE PRECISION / FLOAT[(n)]`	`DOUBLE PRECISION`
`REAL / SMALLFLOAT`	`REAL`
`DECIMAL(p,s)`	`DECIMAL(p,s)`
`DECIMAL(p)` with p<=19	`DECIMAL(2*p,p)`
`DECIMAL(p)` with p>19	N/A
`DECIMAL`	`DECIMAL(32,16)`
`MONEY(p,s)`	`DECIMAL(p,s)`
`MONEY(p)`	`DECIMAL(p,2)`
`MONEY`	`DECIMAL(16,2)`
`DATE`	`DATE` (yyyy-mm-dd)
`DATETIME HOUR TO FRACTION(n)`	`BIGTIME` (hh:mm:ss.ffffff)
`DATETIME HOUR TO SECOND`	`BIGTIME` (hh:mm:ss.ffffff)
`DATETIME q1 TO q2` (different from above)	`BIGDATETIME`(yyyy-mm-dd hh:mm:ss.ffffff)
`INTERVAL q1 TO q2`	`CHAR(50)`
`TEXT`	`TEXT`
`BYTE`	`IMAGE`

Notes: