SQL Data Types

Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below.

1. Binary Datatypes :
There are four subtypes of this datatype which are given below :

2. Exact Numeric Datatype :
There are nine subtypes which are given below in the table. The table contains the range of data in a particular type.

3. Approximate Numeric Datatype :
The subtypes of this datatype are given in the table with the range.

4. Character String Datatype :
The subtypes are given in below table –

5. Unicode Character String Datatype :
The details are given in below table –

6. Date and Time Datatype :
The details are given in below table.

My Personal Notes arrow_drop_up

Save