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. Table 4-2 shows the range of positive numbers supported for each unsigned datatype.
Integer datatypes |
Range |
Storage (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 |
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.
rs_subcmp supports the new
unsigned integer datatypes.
