Numeric data types

HCL Informix® database servers support the following numeric data types:
  • Integer data types: SMALLINT, INTEGER, INT8, SERIAL, SERIAL8
  • The Boolean data type
  • Fixed-point data types: DECIMAL and MONEY
  • Floating-point data types: SMALLFLOAT and FLOAT
These topics contain information about working with numeric data types:
  • Informix ESQL/C data types to use as host variables for SQL numeric data types
  • Characteristics of Informix ESQL/C numeric data types
  • Formatting masks, which you can use to format numeric data types
  • Informix ESQL/C library functions that you can use to manipulate numeric data types