Replication Server 15.0 adds support for the bigint datatype. bigint is a fixed-width, 8-byte datatype. Like int, smallint, and tinyint, bigint is a signed integer datatype. bigint can hold whole numbers between –263 and +(263 – 1).
Table 6-1 describes the range and storage size for all integer datatypes.
Integer datatypes |
Range |
Storage (bytes) |
---|---|---|
bigint |
Whole numbers between –263 and +(263 – 1), inclusive (–9,233,372,036,854,775,808 and +9,233,372,036,854,775,807) |
8 |
int |
Whole numbers between –231 and +(231 – 1), inclusive (–2,147,483,648, and +2,147,483,647) |
4 |
smallint |
Whole numbers between –215 and +(215 – 1), inclusive (–32,768 and +32,767) |
2 |
tinyint |
Positive whole numbers between 0 and 255, inclusive |
1 |
To fully support bigint, the primary and replicate Replication Server must have a site version of 15.0, and the LTL version must be 700. If the LTL version is less than 700 at connect-source time, RepAgent converts bigint columns to numeric.
rs_subcmp supports the new bigint datatype.