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 | −9 223 372 036 854 775 808 to +9 223 372 036 854 775 807 | X | X | BIGINT - A BIGINT (big integer) is an eight byte integer with a precision of 19 digits. |
DECIMAL | NUMERIC | -10**31+1 to 10**31-1 | 15 | 5 | DECIMAL(p,s) - A DECIMAL is a decimal number. The position of the decimal point is determined by the precision (p) and the scale (s) of the number. Precision is the total number of digits and has to be less than 32. Scale is the number of digits in the fractional part and is always smaller than or equal to the value of precision. The decimal value defaults to precision of 5 and scale of 0 if precision and scale are not specified. |
DOUBLE | NUMERIC | Range from -1.79769E+308 to -2.225E-307, or from 2.225E-307 to 1.79769E+308 |
X | X | DOUBLE - (double-precision floating-point number) is a 64 bit approximation of a real number. DOUBLE is also referred to as FLOAT. |
FLOAT | NUMERIC | Range from -1.79769E+308 to -2.225E-307, or from 2.225E-307 to 1.79769E+308 |
X | X | DOUBLE - (double-precision floating-point number) is a 64 bit approximation of a real number. DOUBLE is also referred to as FLOAT. |
INTEGER | NUMERIC | −2 147 483 648 to +2 147 483 647 | X | X | INTEGER - An INTEGER (large integer) is a four byte integer with a precision of 10 digits. |
REAL | NUMERIC | range from -3.402E+38 to -1.175E-37, or from 1.175E-37 to 3.402E+38 |
X | X | REAL - A REAL (single-precision floating-point number) is a 32 bit approximation of a real number. |
SMALLINT | NUMERIC | -32 768 to 32 767 | X | X | SMALLINT - A SMALLINT (small integer) is a two byte integer with a precision of 5 digits. |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 25 | X | X | In 7.2 it comes back as a 'CHARACTER' and 8.1 as a 'CHAR' ... so have both CHAR(x) is a fixed length string. The length attribute x must be between 1 and 254, inclusive. |
CHARACTER | CHARACTER | 25 | X | X | In 7.2 it comes back as a 'CHARACTER' and 8.1 as a 'CHAR' ... so have both CHAR(x) is a fixed length string. The length attribute x must be between 1 and 254, inclusive. |
VARCHAR | CHARACTER | 25 | X | X | Varying-length character strings are of three types: VARCHAR, LONG VARCHAR, and CLOB. |
DATE & TIME DATA TYPES | |||||
DATE | DATE | X | X | X | DATE is a three-part value (year, month, and day). |
TIME | TIME | X | X | X | TIME is a three-part value (hour, minute, and second) designating a time of day using a 24-hour clock. |
TIMESTAMP | TIMESTAMP | X | X | X | TIMESTAMP is a seven-part value (year, month, day, hour, minute, second, and microsecond) designating a date and time. |
BINARY & LARGE OBJECT DATA TYPES | |||||
BLOB | BLOB | 5000 | X | X | |
CLOB | CHARACTER | 5000 | X | X | |
LONG VARCHAR | CHARACTER | X | X | X |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017