Storage Requirements
Variable-length columns whose declared column length is greater than 128 bytes are stored out of line. Variable-length columns whose declared column length is less than or equal to 128 bytes are stored inline. All LOB data types are stored out of line.
For character semantics, the number of bytes stored out of line depends on the character set. For example, for a character set with four bytes per character, variable-length columns whose declared column length is greater than 32 (128/4) are stored out of line.
Table 1-5 shows the storage requirements of the various data types.
Table 1-5 Data type storage requirements
Type | Storage required |
---|---|
|
|
|
Eight bytes |
|
Four bytes |
|
If character semantics, the length of the column ( |
|
Seven bytes |
|
An interval type cannot be stored in TimesTen |
|
Bytes required is 2* |
|
Five to 22 bytes |
|
For 2*(length of value) + 24 bytes (minimum of 40 bytes). For 2*(length of column) + 8 bytes. |
|
Twelve bytes |
|
Twelve bytes |
|
Eight bytes |
|
Four bytes |
|
Four bytes |
|
Two bytes |
|
Eight bytes |
|
Eight bytes |
|
One byte |
|
For Length of value + 24 bytes (minimum of 40 bytes). For Length of column + 8 bytes. |
|
For Length of value + 24 bytes (minimum of 40 bytes). This storage principal holds for all variable length For n + 8 bytes. If character semantics, the length of the column ( |
|
Length of value + 48 bytes (minimum of 56 bytes) |
|
2 * (length of value) + 48 bytes (minimum of 56 bytes) |