Information Type is a quality that determines the kind of information of any item. Every segment, variable and articulation has a connected information type. You can utilize these information types while making your tables. You can pick an information type for a table segment dependent on your necessity.
Derby Server offers a few classifications of information types for your utilization as recorded underneath −
Integer Numeric Data Types
Following is the rundown of whole number numeric information 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 rundown of inexact numeric information 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 rundown of accurate numeric information types −
DATA TYPE | FROM | TO |
---|---|---|
DECIMAL | -10^38 +1 | 10^38 -1 |
NUMERIC | -10^38 +1 | 10^38 -1 |