Data type conversion table

Table 1. Data type conversion table (Informix® vs. MySQL)
Informix data types MySQL data types
CHAR(n) CHAR(n) (n>255c => TEXT(n))
VARCHAR(n[,m]) VARCHAR(n) (n>255c => TEXT(n))
LVARCHAR(n) VARCHAR(n) (n>255c => TEXT(n))
NCHAR(n) NCHAR(n) (n>255c => TEXT(n))
NVARCHAR(n[,m]) NVARCHAR(n) (n>255c => TEXT(n))
BOOLEAN BOOLEAN
SMALLINT SMALLINT
INT / INTEGER INTEGER
BIGINT BIGINT
INT8 BIGINT
SERIAL[(start)] INTEGER (see note)
BIGSERIAL[(start)] BIGINT (see note)
SERIAL8[(start)] BIGINT (see note)
DOUBLE PRECISION / FLOAT[(n)] DOUBLE
REAL / SMALLFLOAT FLOAT
NUMERIC / DEC / DECIMAL(p,s) DECIMAL(p,s)
NUMERIC / DEC / DECIMAL(p) with p<=15 DECIMAL(p*2,p)
NUMERIC / DEC / DECIMAL(p) with >15 N/A
NUMERIC / DEC / DECIMAL DECIMAL(32,16) (unsupported!)
MONEY(p,s) DECIMAL(p,s)
MONEY(p) DECIMAL(p,2)
MONEY DECIMAL(16,2)
DATE DATE
DATETIME HOUR TO SECOND TIME
DATETIME q1 TO q2 (different from above) DATETIME (YYY-MM-DD hh:mm:ss)
INTERVAL q1 TO q2 CHAR(50)
TEXT MEDIUMTEXT / LONGTEXT (using <= 2Gb!)
BYTE MEDIUMBLOB / LONGBLOB (using <= 2Gb!)