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