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:

The CHAR types with a size > 255 are converted TEXT types. For more details, see CHAR and VARCHAR data types.
For more details about serial emulation, see SERIAL and BIGSERIAL data type.
The DECIMAL(32,16) type is not supported by MySQL and MariaDB and will produce an SQL error.