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 -9223372036854775808 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 | 2.2250738585072014e-308 and 1.797693134862315708e+308 | 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 | X | X | X | The value range is 2.22507385850721308 to 1.79769313486231e+308. |
FLOAT | NUMERIC | 1.175494351e-38 to 3.402823466e+38 (If no precision is supplied) |
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 | -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 | |
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. |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 25 | X | X | For strings up to 254 bytes in length |
VARCHAR | CHARACTER | 25 | X | X | For strings up to 254 bytes in length |
SYSNAME | CHARACTER | X | X | X | |
DATE & TIME DATA TIMES | |||||
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. |
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. |
VARBINARY | BINARY | 1 | X | X | Identical to BINARY. |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017