Show TOC

Exact Numeric (Integer) DatatypesLocate this document in the navigation structure

Learn about exact numeric (integer) datatypes.

Replication Server supports these exact numeric (integer) datatypes:
  • <bigint> – whole numbers between -263 and +263 - 1 (-9,233,372,036,854,775,808 and +9,233,372,036,854,775,807), inclusive

  • <int> – whole numbers between -231 and +231 - 1 (-2,147,483,648 and +2,147,483,647), inclusive

  • <smallint> – whole numbers between -215 and +215 - 1 (-32,768 and +32,767), inclusive

  • <tinyint> – positive whole numbers between 0 and 255, inclusive

  • <unsigned bigint> – whole numbers between 0 and 18,446,744, 073, 709,551,615, inclusive

  • <unsigned int> – whole numbers between 0 and 4,294,967,295, inclusive

  • <unsigned smallint> – whole numbers between 0 and 65535, inclusive

  • <unsigned tinyint> – whole numbers between 0 and 255, inclusive.

The <rs_address> datatype, which uses the underlying datatype <int>, is used in a special method of subscription resolution. See the Replication Server Administration Guide Volume 1 for more information on the <rs_address> datatype.