SQL - Data Types
SQL अलग-अलग Data Types रखता है जैसे कि, Numeric, Characters, Binary, date और time जैसे Data Types होते है |
जब SQL में table को create करना पड़ता है तब table के हर column के लिए उसका data type देना पड़ता है |
User अपने जरुरत के मुताबिक data type को चुन सकता है |
Numeric Data Types in SQL
Data Type | Syntax | Range |
---|---|---|
Integer | INT | -231 to +231-1(-2,14,74,83,648 to +2,14,74,83,647) |
Small Integer | SMALLINT | -215 to +215-1(-32768 to +32767) |
Big Integer | BIGINT | -263 to +263-1(92,23,37,20,36,85,47,75,808 to +92,23,37,20,36,85,47,75,807) |
Tiny Integer | TINYINT | 0 to +28-1(0 to 255) |
Bit | BIT | 0 or 1 |
Numeric(Precision, Scale) | NUMERIC(Precision, Scale) | -1038+1 to +1038-1(-1.e+38 to +1.e+38) |
Decimal or Dec | DECIMAL(Precision, Scale) or DEC(Precision, Scale) | -1038+1 to +1038-1(-1.e+38 to +1.e+38) |
Float | FLOAT(Precision) | -1.79E+308 to +1.79E+308 |
Real | REAL | -3.40E + 38 to +3.40E + 38 |
Character Data Types
Data Type | Syntax | Range |
---|---|---|
Character String | CHAR | Maximum 8,000 characters |
Character String | VARCHAR | Maximum 8,000 characters |
Unicode Character String | NCHAR | Maximum 4,000 characters |
Unicode Character String | NVARCHAR | Maximum 4,000 characters |
Character String | TEXT | Maximum 231 = 2,147,483,647 characters |
Unicode Character String | NTEXT | Maximum 230 = 1,073,741,823 characters |
Binary Data Types
Data Type | Syntax | Range |
---|---|---|
Binary Value | BINARY | Maximum 8,000 Bytes |
Binary Value | VARBINARY | Maximum 8,000 Bytes |
Image | IMAGE | Maximum 231 = 2,147,483,647 Bytes |
Date and Time Data Types
Data Type | Syntax | Example |
---|---|---|
date | DATE | For Example, Feb 27, 2015(Format : YYYY-MM-DD) |
time | TIME | For Example, 2:15 A.M.(format : ) |
datetime | DATETIME | Range : January 1, 1753 to December 31, 9999(format : YYYY-MM-DD HH:MI:SS) |
smalldatetime | SMALLDATETIME | Range : January 1, 1900 to June 6, 2079(format : YYYY-MM-DD HH:MI:SS) |
timestamp | TIMESTAMP | format : YYYY-MM-DD HH:MI:SS (store year, month, day, hour, minute and second) |