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 0 to 18446744073709551615 |
X | X | The range for signed BIGINT values is 2 63 to 2 63 1, or 9223372036854775808 to 9223372036854775807. The range for unsigned BIGINT values is 0 to 2 64 1, or 0 to 18446744073709551615. |
BIT | NUMERIC | X | X | X | for Boolean values - By default, columns of BIT data type do not allow NULL. |
DECIMAL | NUMERIC | X | 15 | 5 | The DECIMAL data type is an exact numeric data type; its accuracy is preserved to the least significant digit after arithmetic operations. |
DOUBLE | NUMERIC | Between 2.2250738585072014e-308 and 1.797693134862315708e+308 |
X | X | The value range is 2.22507385850721308 to 1.79769313486231e+308. |
FLOAT | NUMERIC | 1.175494351e-38 to 3.402823466e+38 | X | X | When a column is created using the FLOAT ( precision ) data type, columns on all platforms are guaranteed to hold the values to at least the specified minimum precision. In contrast, REAL and DOUBLE do not guarantee a platform-independent minimum precision. |
INT | NUMERIC | Between -2147483648 and 2147483647 | X | X | |
INTEGER | NUMERIC | X | X | X | The range for signed integers is 31 to 2 31 1, or 2147483648 to 2147483647. The range for unsigned integers is 0 to 2 32 1, or 0 to 4294967295. |
MONEY | NUMERIC | X | X | X | The MONEY data type is implemented as a domain, as NUMERIC(19,4), allowing NULL. |
NUMERIC | NUMERIC | X | 15 | 5 | The NUMERIC data type is an exact numeric data type; its accuracy is preserved to the least significant digit after arithmetic operations. |
OLDBIT | BIT | X | X | X | OLDBIT |
SMALLINT | NUMERIC | Between -32768 and 32767 | X | X | The range for signed SMALLINT values is 2 15 to 2 15 1, or 32768 to 32767. The range for unsigned SMALLINT values is 0 to 2 16 1, or 0 to 65535. |
SMALLMONEY | NUMERIC | X | X | X | The SMALLMONEY data type is implemented in Adaptive Server Anywhere as a domain, as NUMERIC(10,4), allowing NULL. |
TINYINT | NUMERIC | Between 0 and 255 | X | X | The range for TINYINT values is 0 to 2 8 1, or 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. | |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 1 through 254 |
X | X | For strings up to 254 bytes in length |
SYSNAME | CHARACTER | X | X | X | |
VARCHAR | CHARACTER | 1 through 254 | X | X | For strings up to 254 bytes in length |
DATE & TIME DATA TYPES | |||||
DATE | DATETIME | 0001-01-01 to 9999-12-31 | X | X | A calendar date, such as a year, month and day. - Including Hours and Minutes |
DATETIME | TIMESTAMP | X | X | X | A domain, implemented as TIMESTAMP. - Backward compat to ASE |
SMALLDATETIME | DATETIME | X | X | X | A domain, implemented as TIMESTAMP. - Backward compat to ASE |
TIME | TIME | 00:00:00.000000 to 23:59:59.999999 | X | X | The time of day, containing hour, minute, second and fraction of a second. |
TIMESTAMP | TIMESTAMP | 0001-01-01 00:00:00.000000 to 9999-12-31 23:59:59.999999 | X | X | The point in time, containing year, month, day, hour, minute, second and fraction of a second. |
BINARY & LARGE OBJECT DATA TYPES | |||||
BINARY | BINARY | 1 | X | X | Binary data - The maximum size allowed is 32767. |
BLOB | BINARY | X | X | X | BLOB binary large objects |
CLOB | BINARY | X | X | X | CLOB character large objects |
IMAGE | BLOB | X | X | X | LONG BINARY data allowing NULL. |
LONG BINARY | BINARY | X | X | X | Binary data greater than 32K and less than 64K bytes for databases with IQ page size 128KB or larger. Use the binary data type LONG BINARY for data over 32KB in length. IQ handles LONG BINARY columns as VARBINARY columns. |
LONG VARCHAR | CHARACTER | X | X | X | LONG BINARY - Long Binary - The maximum size is limited by the maximum size of the database file. Arbitrary length strings. The maximum size is limited by the maximum size of the database file (currently 2 Gb). |
TEXT | CHARACTER | X | X | X | This is a domain. It is implemented as a LONG VARCHAR allowing NULL. |
VARBINARY | BINARY | 1 | X | X | Identical to BINARY. |
XML | X | X | X | XML data |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017