SQL Data Type defines the type of Data that is going to be stored in a column. Most of the RDBMS will define use their own datatypes. So You may not find all datatypes of Ms SQL server in MySQL or ViceVersa.
SQL Server provides a large number of data types that allows further data manipulation. There are four main groups:
1. Numbers:
|
Type |
From |
To |
|
bigint |
-9,223,372,036,854,775,808 |
9,223,372,036,854,775,807 |
|
int |
-2,147,483,648 |
2,147,483,647 |
|
smallint |
-32,768 |
32,767 |
|
tinyint |
0 |
255 |
|
bit |
0 |
1 |
|
decimal |
-1038 +1 |
1038 –1 |
|
numeric |
-1038 +1 |
1038 –1 |
|
money |
-922,337,203,685,477.5808 |
+922,337,203,685,477.5807 |
|
smallmoney |
-214,748.3648 |
+214,748.3647 |
2. Date:
|
Type |
From |
To |
|
Datetime |
Jan 1, 1753 |
Dec 31, 9999 |
|
smalldatetime |
Jan 1, 1900 |
Jun 6, 2079 |
3. Characters:
|
Type |
Description |
|
char |
Fixed-length non-Unicode character data with a maximum length of 8,000 characters. |
|
varchar |
Variable-length non-Unicode data with a maximum of 8,000 characters. |
|
text |
Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters. |
|
nchar |
Fixed-length Unicode data with a maximum length of 4,000 characters. Wide characters support ( e.g. Chinese, Arabic, etc) |
|
nvarchar |
Variable-length Unicode data with a maximum length of 4,000 characters. ( e.g. Chinese, Arabic, etc) |
|
ntext |
Variable-length Unicode data with a maximum length of 1,073,741,823 characters. ( e.g. Chinese, Arabic, etc) |
4. Binary:
|
Type |
Description |
|
binary |
Fixed-length binary data with a maximum length of 8,000 bytes. |
|
varbinary |
Variable-length binary data. Maximum length 8,000 bytes. |
|
image |
Variable-length binary data. Maximum length 2,147,483,647 bytes. |