- Apache Derby Tutorial
- Apache Derby - Home
- Apache Derby - Introduction
- Apache Derby - Deployment Modes
- Apache Derby - Environment Setup
- Apache Derby - Tools
- Apache Derby - Syntax
- Apache Derby - Data Types
- Apache Derby - Create Table
- Apache Derby - Drop Table
- Apache Derby - Insert Data
- Apache Derby - Retrieve Data
- Apache Derby - Update Data
- Apache Derby - Delete Data
- Apache Derby - Where Clause
- Apache Derby - GROUP BY Clause
- Apache Derby - Order By Clause
- Apache Derby - Having Clause
- Alter Table Statement
- Apache Derby - Derby Indexes
- Apache Derby - Procedures
- Apache Derby - Schemas
- Apache Derby - Triggers
- Apache Derby Useful Resources
- Apache Derby - Quick Guide
- Apache Derby - Useful Resources
- Apache Derby - Discussion
Apache Derby - Data Types
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