BIGINT and INTEGER exist as Drizzle’s two integer numerical types. BIGINT is a 64-bit integer, while INTEGER is a 32-bit integer.
Drizzle does not support TINYINT, SMALLINT or MEDIUMINT. Integer operations have been optimized around 32- and 64-bit integers.
Name | Storage Size | Description | Range |
---|---|---|---|
integer | 4 bytes | most common integer | -2147483648 to +2147483647 |
bigint | 8 bytes | larger-range integer | -9223372036854775808 to 9223372036854775807 |
AUTO_INCREMENT is supported for INT and BIGINT.
DOUBLE is the system’s native double type. DOUBLE represents double-precision floating-point values that require eight bytes each for storage.