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
825
|
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 | X | 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 | X | 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 | X | 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 | X | 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 | 1 and 254, inclusive | 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 | 1 and 254, inclusive | 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 | |
DBCLOB | CHARACTER | X | X | X | A double-byte character large object is a varying-length graphic string of double-byte characters that can be up to 1,073,741,823 characters long. |
GRAPHIC | CHARACTER | Between 1 and 127 | X | X | A fixed-length graphic string is between 1 and 127 double-byte characters long. If a length is not specified, it is assumed to be 1 double-byte character. |
LONG VARCHAR | CHARACTER | X | X | X | |
LONG VARGRAPHIC | CHARACTER | X | X | X | are varying-length graphic strings that can be up to 16,350 double-byte characters long. |
VARGRAPHIC | CHARACTER | X | X | X | are varying-length graphic strings that can be up to 16,336 double-byte characters long. |
XML | XML | X | X | X |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017