Data type conversion table

Table 1. Data type conversion table between Informix® and SQLite
Informix data types SQLite data types
CHAR(n) CHAR(n) COLLATE RTRIM
VARCHAR(n[,m]) VARCHAR(n) COLLATE RTRIM
LVARCHAR(n) VARCHAR(n) COLLATE RTRIM
NCHAR(n) NCHAR(n)
NVARCHAR(n) NVARCHAR(n)
BOOLEAN BOOLEAN
SMALLINT SMALLINT
INT / INTEGER INTEGER
BIGINT BIGINT
INT8 BIGINT
SERIAL[(start)] INTEGER (see note)
BIGSERIAL[(start)] N/A (see note)
INT8[(start)] N/A (see note)
DOUBLE PRECISION / FLOAT[(n)] FLOAT
REAL / SMALLFLOAT SMALLFLOAT
NUMERIC / DEC / DECIMAL(p,s) DECIMAL(p,s)
NUMERIC / DEC / DECIMAL(p) DECIMAL(p,s)
NUMERIC / DEC / DECIMAL DECIMAL
MONEY(p,s) DECIMAL(p,s)
MONEY(p) DECIMAL(p,2)
MONEY DECIMAL(16,2)
TEXT TEXT
BYTE BLOB
DATE DATE
DATETIME HOUR TO SECOND TIME
DATETIME q1 TO q2 (different from above) TIMESTAMP
INTERVAL q1 TO q2 CHAR(50)