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 |

