Data type conversion table: Informix to MySQL

Table 1. Data type conversion table (Informix® to Oracle® MySQL)
Informix data types Oracle MySQL data types
CHAR(n) CHAR(n) or TEXT (see note 1)
VARCHAR(n[,m]) VARCHAR(n)
LVARCHAR(n) VARCHAR(n)
NCHAR(n) NCHAR(n)
NVARCHAR(n[,m]) NVARCHAR(n)
BOOLEAN BOOLEAN
SMALLINT SMALLINT
INTEGER INTEGER
BIGINT BIGINT
INT8 BIGINT
SERIAL[(start)] INTEGER (see note 2)
BIGSERIAL[(start)] BIGINT (see note 2)
SERIAL8[(start)] BIGINT (see note 2)
DOUBLE PRECISION / FLOAT[(n)] DOUBLE
REAL / SMALLFLOAT FLOAT
DECIMAL(p,s) DECIMAL(p,s)
DECIMAL(p) with p<=15 DECIMAL(p*2,p)
DECIMAL(p) with >15 N/A
DECIMAL DECIMAL(32,16) (see note 3)
MONEY(p,s) DECIMAL(p,s)
MONEY(p) DECIMAL(p,2)
MONEY DECIMAL(16,2)
DATE DATE
DATETIME HOUR TO MINUTE TIME
DATETIME HOUR TO SECOND TIME
DATETIME HOUR TO FRACTION(p) TIME(p)
DATETIME YEAR TO MONTH DATETIME
DATETIME YEAR TO DAY DATETIME
DATETIME YEAR TO HOUR DATETIME
DATETIME YEAR TO MINUTE DATETIME
DATETIME YEAR TO SECOND DATETIME
DATETIME YEAR TO FRACTION(p) DATETIME(p)
INTERVAL q1 TO q2 CHAR(50)
TEXT MEDIUMTEXT / LONGTEXT (max is 2Gb)
BYTE MEDIUMBLOB / LONGBLOB (max is 2Gb)
Notes:
  1. The CHAR types with a size > 255 are converted TEXT types. For more details, see CHAR and VARCHAR data types.
  2. For more details about serial emulation, see SERIAL and BIGSERIAL data type.
  3. The DECIMAL(32,16) type is not supported by MySQL and MariaDB and will produce an SQL error.