Data type conversion table: Informix to Netezza

Table 1. Data type conversion table (Informix to Netezza)
Informix® data types	Netezza® data types
`CHAR(n)`	`CHAR(n)` if SBCS, `NCHAR(n)` if UTF-8
`VARCHAR(n[,m])`	VARCHAR(n) if SBCS, `NVARCHAR(n)` if UTF-8
`NCHAR(n)`	`NCHAR(n)` (UTF-8)
`NVARCHAR(n[,m])`	`NVARCHAR(n)` (UTF-8)
`BOOLEAN`	`BOOLEAN`
`SMALLINT`	`SMALLINT`
`INTEGER`	`INTEGER`
`BIGINT`	`BIGINT`
`INT8`	`BIGINT`
`SERIAL[(start)]`	N/A (see note 1)
`BIGSERIAL[(start)]`	N/A (see note 1)
`SERIAL8[(start)]`	N/A (see note 1)
`DOUBLE PRECISION / FLOAT[(n)]`	`DOUBLE`
`REAL / SMALLFLOAT`	`REAL`
`DECIMAL(p,s)`	`DECIMAL(p,s)`
`DECIMAL(p)`	`DECIMAL(p*2,p)`
`DECIMAL`	`DECIMAL(32,16)`
`MONEY(p,s)`	`DECIMAL(p,s)`
`MONEY(p)`	`DECIMAL(p,2)`
`MONEY`	`DECIMAL(16,2)`
`TEXT`	N/A
`BYTE`	N/A
`DATE`	`DATE`
`DATETIME HOUR TO MINUTE`	`TIME`
`DATETIME HOUR TO SECOND`	`TIME`
`DATETIME HOUR TO FRACTION(n)`	`TIME`
`DATETIME YEAR TO MONTH`	`TIMESTAMP`
`DATETIME YEAR TO DAY`	`TIMESTAMP`
`DATETIME YEAR TO HOUR`	`TIMESTAMP`
`DATETIME YEAR TO MINUTE`	`TIMESTAMP`
`DATETIME YEAR TO SECOND`	`TIMESTAMP`
`DATETIME YEAR TO FRACTION(n)`	`TIMESTAMP`
`INTERVAL YEAR[(p)] TO MONTH`	`CHAR(50)`
`INTERVAL YEAR[(p)] TO YEAR`	`CHAR(50)`
`INTERVAL MONTH[(p)] TO MONTH`	`INTERVAL`
`INTERVAL DAY[(p)] TO FRACTION(n)`	`INTERVAL`
`INTERVAL DAY[(p)] TO SECOND`	`INTERVAL`
`INTERVAL DAY[(p)] TO MINUTE`	`INTERVAL`
`INTERVAL DAY[(p)] TO HOUR`	`INTERVAL`
`INTERVAL DAY[(p)] TO DAY`	`INTERVAL`
`INTERVAL HOUR[(p)] TO FRACTION(n)`	`INTERVAL`
`INTERVAL HOUR[(p)] TO SECOND`	`INTERVAL`
`INTERVAL HOUR[(p)] TO MINUTE`	`INTERVAL`
`INTERVAL HOUR[(p)] TO HOUR`	`INTERVAL`
`INTERVAL MINUTE[(p)] TO FRACTION(n)`	`INTERVAL`
`INTERVAL MINUTE[(p)] TO SECOND`	`INTERVAL`
`INTERVAL MINUTE[(p)] TO MINUTE`	`INTERVAL`
`INTERVAL SECOND[(p)] TO FRACTION(n)`	`INTERVAL`
`INTERVAL SECOND[(p)] TO SECOND`	`INTERVAL`
`INTERVAL FRACTION[(p)] TO FRACTION(n)`	`INTERVAL`

Notes:

For more details about serial emulation, see SERIAL and BIGSERIAL data types.