New Unsigned Integer Datatypes

Replication Server version 15.0 supports four new unsigned integer datatypes.

You can use these unsigned datatypes in the same way as their signed equivalents:

unsigned tinyint – tinyint
unsigned smallint – smallint
unsigned int – int
unsigned bigint – bigint

Signed integers are whole positive or negative numbers. Unsigned integers are only whole positive numbers. The storage sizes of the signed and unsigned integers datatypes are the same. The table shows the range of positive numbers supported for each unsigned datatype.

Unsigned Integer Datatypes
Integer Datatypes	Range	Storage (in Bytes)
`unsigned bigint`	Whole numbers between 0 and 18,446,744, 073, 709,551,615, inclusive	8
`unsigned int`	Whole numbers between 0 and 4,294,967,295, inclusive	4
`unsigned smallint`	Whole numbers between 0 and 65535, inclusive	2
`unsigned tinyint`	Positive whole numbers between 0 and 255, inclusive	1

Mixed-Version Issues

To fully support the unsigned integer datatypes, 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 makes these datatype conversions:

unsigned bigint –> numeric
unsigned int –> numeric
unsigned smallint –> int
unsigned tinyint –> tinyint

Replication definitions created with unsigned integer datatypes are not sent to Replication Servers version 12.5.x and earlier. If a replication definition is subscribed by Replication Server version 12.5.x, it cannot be altered to add unsigned integer columns.

Note: rs_subcmp supports the new unsigned integer datatypes.