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:

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 data type.
Only with MySQL >= 5.6.4 and MariaDB >= 5.3.0, for older versions DATETIME cannot use a frational part.
The DECIMAL(32,16) type is not supported by MySQL and MariaDB and will produce an SQL error.