Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
825
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES |
|||||
BIT | BIT | X | X | X | 0 or 1 |
DECIMAL | NUMERIC | 1038 -1 to -1038 | 15 | 5 | Number 2^38 to -2^38 |
DOUBLE PRECISION | NUMERIC | X | X | X | Machine dependant Double precision is what comes back from the database for a FLOAT defenition |
FLOAT | NUMERIC | X | X | X | |
INT | NUMERIC | 231 -1 (2,147,483,647) to -231 (-2,147,483,648) |
X | X | Number 2^31 to -2^31 (2mill to - 2mill) |
MONEY | NUMERIC | 922,337,203,685,477.5807 to -922,337,203,685,477.5808 |
X | X | 922,337,203,685,477.5807 to -922,337,203,685,477.5808 |
NUMERIC | NUMERIC | 1038 -1 to -1038 | 15 | 5 | Number 2^38 to -2^38 |
REAL | NUMERIC | X | X | X | Machine dependant |
SMALLINT | NUMERIC | 215 -1 (32,767) to -215 (-32,768) | X | X | Number 2^15 to -2^15 (32,767 to -32,767) |
SMALLMONEY | NUMERIC | 214,748.3647 to -214,748.3648 | X | X | 214,748.3647 to -214,748.3648 |
TINYINT | NUMERIC | 0 to 255 | X | X | Number 0 - 255 |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 25 | X | X | Character 0 to 255 |
NCHAR | CHARACTER | 25 | X | X | Character 0 to 255 |
NVARCHAR | CHARACTER | 25 | X | X | Character 0 to 255 |
SYSNAME | CHARACTER | X | X | X | Character 0 to 255 |
UNICHAR | CHARACTER | X | X | X | Character 0 to 255 -- ? some docs say UNI some N |
UNIVARCHAR | CHARACTER | X | X | X | Character 0 to 255 -- ? some docs say UNI some N |
VARCHAR | CHARACTER | 25 | X | X | Character 0 to 255 |
DATE & TIME DATA TYPES | |||||
DATE | DATE | X | X | X | January 1, 1753 to December 31, 9999 |
DATETIME | TIMESTAMP | January 1, 1753 to December 31, 9999 | X | X | January 1, 1753 to December 31, 9999 |
SMALLDATETIME | DATETIME | January 1, 1900 to June 6, 2079 | X | X |
January 1, 1900 to June 6, 2079 |
TIME | TIME | 12:00:00AM to 11:59:59:999PM | X | X |
12:00:00AM to 11:59:59:999PM |
TIMESTAMP | CHARACTER | X | X | X | Every time a row containing a timestamp column is inserted or updated, the timestamp column is automatically updated. A table can have only one column of the timestamp datatype. A column named timestamp will automatically have the system datatype timestamp. Its definition is varbinary(8) NULL. |
BINARY & LONG OBJECT DATA TYPES | |||||
BINARY | BINARY | 1 | X | X | Binary 0 - 256 bypes |
IMAGE | BLOB | 231 -1 (2,147,483,647) bytes or fewer | X | X | Binary 2 ^31 |
TEXT | CHARACTER | 231 -1 (2,147,483,647) bytes or fewer | X | X | Characters 2 ^31 |
VARBINARY | BINARY | 1 | X | X | Binary 0 - 255 bytes |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017