Data type conversion table: Informix to SQLite

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 1)
BIGSERIAL[(start)] N/A (see note 1)
INT8[(start)] N/A (see note 1)
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 MINUTE SMALLTIME
DATETIME HOUR TO SECOND TIME
DATETIME HOUR TO FRACTION(n) TIME(n)
DATETIME YEAR TO DAY TINYDATETIME
DATETIME YEAR TO MINUTE SMALLDATETIME
DATETIME YEAR TO SECOND DATETIME
DATETIME YEAR TO FRACTION(n) DATETIME(n)
DATETIME q1 TO q2 (different from above) TIMESTAMP
INTERVAL q1 TO q2 CHAR(50)
Notes:
  1. For more details about serial emulation, see SERIAL data types.