SQL and supported and unsupported data types
When using DRDA, IBM® Informix® syntax is supported over the common API. When using DRDA connections, Informix rounds decimal and money values to 32-digit precision for all data retrieval operations on decimal or money data types.
The following data types are supported over the common
API:
- BIGINT
- BIGSERIAL
- BLOB
- BOOLEAN
- BSON
- BYTE
- CHAR(32k)
- CLOB
- DATE
- DATETIME
- DECIMAL
- FLOAT
- INT
- INT8
- INTERVAL
- JSON
- LVARCHAR(32k)
- MONEY
- NCHAR(32k)
- NVARCHAR(255)
- SERIAL
- SERIAL8
- SMALLFLOAT
- SMALLINT
- TEXT
- VARCHAR(255)
Informix DATETIME values are mapped to DATE, TIME, or TIMESTAMP values.
The following
data types are supported for use with database server host variables:
- CHAR
- DATE
- INT
- SMALLINT
- VCHAR