1994.4.23
by Marisa Plumb
new data types content |
1 |
Numeric Data Types
|
2 |
==================
|
|
3 |
||
2194.5.3
by Andrew Hutchings
Markup fixes |
4 |
``BIGINT`` and ``INTEGER`` exist as Drizzle's two integer numerical types. |
5 |
``BIGINT`` is a 64-bit integer, while ``INTEGER`` is a 32-bit integer. |
|
1994.5.19
by Stewart Smith
rearrange explanation of absence of old weird types in numeric data types doc to be after explanation of what we do have. I think it reads better that way |
6 |
|
2194.5.3
by Andrew Hutchings
Markup fixes |
7 |
:program:`Drizzle` does not support ``TINYINT``, ``SMALLINT`` or ``MEDIUMINT``. |
8 |
Integer operations have been optimized around 32- and 64-bit integers. |
|
1994.4.31
by Marisa Plumb
numeric types |
9 |
|
10 |
+---------+--------------+---------------------+--------------------------------------------+ |
|
11 |
|Name |Storage Size |Description |Range | |
|
12 |
+=========+==============+=====================+============================================+ |
|
13 |
|integer |4 bytes |most common integer |-2147483648 to +2147483647 | |
|
14 |
+---------+--------------+---------------------+--------------------------------------------+ |
|
15 |
|bigint |8 bytes |larger-range integer |-9223372036854775808 to 9223372036854775807 | |
|
16 |
+---------+--------------+---------------------+--------------------------------------------+ |
|
17 |
||
2194.5.3
by Andrew Hutchings
Markup fixes |
18 |
``AUTO_INCREMENT`` is supported for ``INT`` and ``BIGINT``. |
1994.4.31
by Marisa Plumb
numeric types |
19 |
|
2194.5.3
by Andrew Hutchings
Markup fixes |
20 |
``DOUBLE`` is the system's native double type. ``DOUBLE`` represents |
21 |
double-precision floating-point values that require eight bytes each for |
|
22 |
storage. |