Apache Derby - Data Types

Advertisements

Previous Page
Next Page  

Data Type is an attribute that specifies the type of data of any object. Each column, variable and expression has a related data type. You can use these data types while creating your tables. You can choose a data type for a table column based on your requirement.

Derby Server offers several categories of data types for your use as listed below −

Integer Numeric Data Types

Following is the list of integer numeric data types −

DATA TYPE SIZE FROM TO
SMALLINT 2 bytes -32768 32767
INTEGER 4 bytes -2,147,483,648 2,147,483,647
BIGINT 8 bytes -9223372036854775808 9223372036854775808

Approximate Numeric Data Types

Following is the list of approximate numeric data types −

DATA TYPE SIZE FROM TO
REAL 4 bytes -3.40E + 38 3.40E + 38
DOUBLE PRECISION 8 bytes -1.79E + 308 1.79E + 308
FLOAT -1.79E + 308 1.79E + 308

Exact Numeric Data Types

Following is the list of exact numeric data types −

DATA TYPE FROM TO
DECIMAL -10^38 +1 10^38 -1
NUMERIC -10^38 +1 10^38 -1
Advertisements