Apache Derby: Data Types Cheat Sheet

Integer Numeric Data Types

Data typeSizeFromTo
SMALLINT2 bytes-3276832767
INTEGER4 bytes-2,147,483,6482,147,483,647
BIGINT8 bytes-92233720368547758089223372036854775808

Approximate Numeric Data Types

Data typeSizeFromTo
REAL4 bytes-3.40E + 383.40E + 38
DOUBLE PRECISION8 bytes-1.79E + 3081.79E + 308
FLOAT-1.79E + 3081.79E + 308

Exact Numeric Data Types

Data typeFromTo
DECIMAL-10^38 +110^38 -1
NUMERIC-10^38 +110^38 -1

Leave a Reply

Your email address will not be published. Required fields are marked *