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 4)
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) (see note 3)
DATETIME YEAR TO MINUTE DATETIME
DATETIME YEAR TO SECOND DATETIME
DATETIME YEAR TO FRACTION(p) DATETIME(p) (see note 3)
DATETIME q1 TO q2 (others than above) DATETIME(p) (see note 3)
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 data type.
  3. Only with MySQL >= 5.6.4 and MariaDB >= 5.3.0, for older versions DATETIME cannot use a frational part.
  4. The DECIMAL(32,16) type is not supported by MySQL and MariaDB and will produce an SQL error.