Integer binary representations
The DataBlade®
API provides
the following data types to support the binary representations of
integer values.
| Integer data | DataBlade API data type | SQL integer data type |
|---|---|---|
| One-byte integers | mi_sint1, mi_int1 | None |
| Two-byte integers | mi_smallint, mi_unsigned_smallint | SMALLINT |
| Four-byte integers | mi_integer, mi_unsigned_integer | INTEGER, SERIAL |
| Eight-byte integers | mi_int8, mi_unsigned_int8, mi_bigint, mi_unsigned_bigint | INT8, SERIAL8, BIGINT, BIGSERIAL |
Tip: The internal format of integer data types
is often referred to as their binary representation.