"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/numeric_data_types.rst" (6 May 2012, 1200 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:

As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

Numeric Data Types

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 |-214 7483648 to +2147483647
bigint 8 bytes |larg er-range integer |-922 3372036854775808 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.