|
Column type
|
Size
|
|---|---|
|
TINYINT
|
2 bytes
|
|
SMALLINT
|
2 bytes
|
|
INT
|
4 bytes
|
|
BIGINT
|
8 bytes
|
|
DATE/TIME/ TIMESTAMP
|
11 bytes
|
|
FLOAT / DOUBLE PRECISION
|
8 bytes
|
|
REAL
|
4 bytes
|
|
NUMERIC / DECIMAL
|
12 bytes
|
|
CHAR / VARCHAR / LONG VARCHAR
|
char_length(column_value) + 5
|
|
WCHAR / WVARCHAR / LONG WVARCHAR
|
char_length(column_value) * 2 + 5
|
|
BINARY / VARBINARY / LONG VARBINARY
|
octet_length(column_value) + 5
|