Show TOC

Approximate Numeric (Floating Point) DatatypesLocate this document in the navigation structure

Learn about numeric (floating point) datatypes.

There are two approximate numeric (floating point) datatypes:
  • <float> – positive or negative floating point numbers. Precision and number of significant digits are machine-dependent. Storage size is 8 bytes.

  • <real> – like <float> except the storage size is 4 bytes.

Do not include columns using the approximate numeric (floating point) datatypes in the primary key of the replication definition.