Supported data types
The following table shows the IBM Informix database source data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped in the target, see the section for the target database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
| IBM Informix Source Data Types | Qlik Replicate Data Types |
|---|---|
|
INTEGER |
INT4 |
|
SMALLINT |
INT2 |
|
INT8 |
INT8 |
|
SERIAL |
INT4 |
|
SERIAL8 |
INT8 |
|
NUMERIC (p,s) |
NUMERIC (p,s) |
|
DECIMAL (p,s) |
NUMERIC (p,s) |
|
MONEY (p,s) |
NUMERIC (p,s) |
|
FLOAT |
REAL8 |
|
DOUBLE |
REAL8 |
|
REAL |
REAL4 |
|
SMALLFLOAT |
REAL4 |
|
BIGINT |
STRING (20) |
|
DATE |
DATE |
|
DATETIME (fraction) |
DATETIME (fraction) |
|
INTERVAL |
STRING |
|
CHAR |
STRING (n) |
|
VARCHAR (n) |
STRING (n) |
|
LVARCHAR (n) |
STRING (n) |
|
NCHAR (n) |
STRING (n) |
|
NVARCHAR (n) |
STRING (n) |
|
BLOB |
BLOB |
|
BYTE |
BLOB |
|
CLOB |
CLOB |
|
LIST See also Limitations and considerations. |
CLOB |
|
MULTISET See also Limitations and considerations. |
CLOB |
|
SET See also Limitations and considerations. |
CLOB |
|
TEXT |
CLOB |
|
BOOLEAN |
BOOLEAN |