Numeric data types

HCL OneDB™ 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:
  • data types to use as host variables for SQL numeric data types
  • Characteristics of numeric data types
  • Formatting masks, which you can use to format numeric data types
  • library functions that you can use to manipulate numeric data types