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 | –263 to 263–1 | X | X | bigint - Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). Seems like this converts to Numeric in JDBC Result sets |
BIT | BIT | X | X | X | bit - Integer data with either a 1 or 0 value. |
DECIMAL | NUMERIC | –1038+1 to 1038–1 | 15 | 5 | binary - Fixed-length binary data with a maximum length of 8,000 bytes. decimal - Fixed precision and scale numeric data from -10^38 +1 through 10^38 1. |
FLOAT | NUMERIC | –1.79308 to –2.23308, 0, and 2.23308 to 1.79308 | X | X | float - Floating precision number data from -1.79E + 308 through 1.79E + 308. |
INT | NUMERIC | –231 to 231–1 | X | X | int - Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). |
MONEY | NUMERIC | –922,337,203,685,477.5808 to 922,337,203,685,477.5807 | X | X | money - Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. |
NUMERIC | NUMERIC | –1038+1 to 1038–1 | 15 | 5 | numeric - Functionally equivalent to decimal. |
REAL | NUMERIC | –3.438 to –1.1838, 0, and 1.1838 to 3.438 | X | X | real - Floating precision number data from -3.40E + 38 through 3.40E + 38. |
SMALLINT | NUMERIC | –32,768 to 32,767 | X | X | smallint - Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767). |
SMALLMONEY | NUMERIC | –214,748.3648 to 214,748.3647 | X | X | smallmoney - Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. |
UNIQUEIDENTIFIER | CHARACTER | X | X | X | uniqueidentifier - A globally unique identifier (GUID). |
TINYINT | NUMERIC | 0 to 255 | X | X | tinyint - Integer data from 0 through 255. |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 25 | X | X | char - Fixed-length non-Unicode character data with a maximum length of 8,000 characters. |
NCHAR | CHARACTER | 25 | X | X | nchar - Fixed-length Unicode data with a maximum length of 4,000 characters |
NTEXT | CHARACTER | X | X | X | ntext - Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. |
NVARCHAR | CHARACTER | 25 | X | X | nvarchar - Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names. |
TEXT | CHARACTER | X | X | X | text - Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. |
VARCHAR | CHARACTER | 25 | X | X | varchar - Variable-length non-Unicode data with a maximum of 8,000 characters. |
DATE & TIME DATA TYPES | |||||
DATE | X | X | A date. Defines a date. | ||
DATETIME | TIMESTAMP | 1753-01-01 through 9999-12-31 | X | X | datetime - Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds. |
DATETIME2 | X | X | datetime2 - Defines a date that is combined with a time of day that is based on 24-hour clock. datetime2 can be considered as an extension of the existing datetime type that has a larger date range, a larger default fractional precision, and optional user-specified precision. | ||
DATETIMEOFFSET | X | X | datetimeoffset - Defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock. | ||
SMALLDATETIME | DATETIME | X | X | X | smalldatetime - Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. |
TIME | X | X | X | A time. Defines a time of a day. The time is without time zone awareness and is based on a 24-hour clock. | |
TIMESTAMP | CHARACTER | X | X | X | timestamp - A database-wide unique number that gets updated every time a row gets updated. |
BINARY & LARGE OBJECT DATA TYPES | |||||
BINARY | BINARY | 1 | X | X | |
HIERARCHYID | X | X | X | The hierarchyid data type is a variable length, system data type. Use hierarchyid to represent position in a hierarchy. A column of type hierarchyid does not automatically represent a tree. It is up to the application to generate and assign hierarchyid values in such a way that the desired relationship between rows is reflected in the values. | |
IMAGE | BLOB | X | X | X | image - Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes. |
VARBINARY | BINARY | 1 | X | X | varbinary - Variable-length binary data with a maximum length of 8,000 bytes. |
SQL_VARIANT | BINARY | X | X | X | sql_variant - A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant. |
XML | XML | X | X | X |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017