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
DATETIME HOUR TO MINUTE BIGTIME
DATETIME HOUR TO SECOND BIGTIME
DATETIME HOUR TO FRACTION(n) BIGTIME
DATETIME YEAR TO MONTH BIGTIME
DATETIME YEAR TO DAY BIGDATETIME
DATETIME YEAR TO HOUR BIGDATETIME
DATETIME YEAR TO MINUTE BIGDATETIME
DATETIME YEAR TO SECOND BIGDATETIME
DATETIME YEAR TO FRACTION(n) BIGDATETIME
INTERVAL q1 TO q2 CHAR(50)
TEXT TEXT
BYTE IMAGE
Notes:
  1. For more details about serial emulation, see SERIAL and BIGSERIAL data type.