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
824
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES | |||||
BIGINT | NUMERIC | Signed - Between -9223372036854775808 and 9223372036854775807 Unsigned - from 0 to 18446744073709551615 |
X | X | |
BIT | BIT | X | X | X | 0 or 1 |
DECIMAL | NUMERIC | X | 15 | 5 | Number 2^38 to -2^38 |
DOUBLE PRECISION | NUMERIC | 2.2250738585072014e-308 and 1.797693134862315708e+308 | X | X | Machine dependant Double precision is what comes back from the database for a FLOAT defenition |
FLOAT | NUMERIC | 1.175494351e-38 to 3.402823466e+38 |
X | X | |
INT | NUMERIC | Between -2147483648 and 2147483647 | X | X | Number 2^31 to -2^31 (2mill to - 2mill) |
MONEY | NUMERIC | X | X | X | 922,337,203,685,477.5807 to -922,337,203,685,477.5808 |
NUMERIC | NUMERIC | X | 15 | 5 | Number 2^38 to -2^38 |
OLDBIT | BINARY | X | X | X | OLDBIT |
REAL | NUMERIC | 1.175494351e-38 to 3.402823466e+38 | X | X | Machine dependant |
SMALLINT | NUMERIC | Between -32768 and 32767 | X | X | Number 2^15 to -2^15 (32,767 to -32,767) |
SMALLMONEY | NUMERIC | X | X | X | 214,748.3647 to -214,748.3648 |
TINYINT | NUMERIC | Between 0 and 255 | X | X | Number 0 - 255 |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 25 | X | X | Character 0 to 255 |
SYSNAME | CHARACTER | X | X | X | Character 0 to 255 |
UNIQUEIDENTIFIER | CHARACTER | X | X | X | |
UNIQUEIDENTIFIERSTR | X | X | X | Domain implemented as CHAR( 36 ). This data type is used for remote data access, when mapping Microsoft SQL Server uniqueidentifier columns. | |
VARCHAR | CHARACTER | 25 | X | X | Character 0 to 255 |
DATE & TIME DATA TYPES | |||||
DATE | DATE | 0001-01-01 to 9999-12-31 | X | X | January 1, 1753 to December 31, 9999 |
DATETIME | TIMESTAMP | 00:00:00.000000 to 23:59:59.999999 | X | X | January 1, 1753 to December 31, 9999 |
SMALLDATETIME | DATETIME | X | X | X | January 1, 1900 to June 6, 2079 |
TIME | X | X | |||
TIMESTAMP | CHARACTER | 0001-01-01 00:00:00.000000 to 9999-12-31 23:59:59.999999 | 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 & LARGE OBJECT DATA TYPES | |||||
BINARY | BINARY | 1 | X | X | Binary 0 - 256 bypes |
BLOB | BINARY | X | X | X | BLOB binary large objects |
CLOB | BINARY | X | X | X | CLOB character large objects |
IMAGE | BLOB | X | X | X | Binary 2 ^31 |
TEXT | CHARACTER | X | 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