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 |
BINARY DATA TYPES | |||||
BINARY | BINARY | 1 to 65000 | X | X | Fixed-length binary string |
VARBINARY | BINARY | 1 to 65000 | X | X | Variable-length binary string |
LONG VARBINARY | BINARY | 1 to 32000000 | X | X | Long variable-length binary string |
BYTEA | BINARY | 1 to 65000 | X | X | Variable-length binary string (synonym for VARBINARY) |
RAW | BINARY | 1 to 65000 | X | X | Variable-length binary string (synonym for VARBINARY) |
BOOLEAN DATA TYPES | |||||
BOOLEAN | BOOLEAN | 1 | X | X | True or False or NULL |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | 1 to 65000 | X | X | Fixed-length character string |
VARCHAR | CHARACTER | 1 to 65000 | X | X | Variable-length character string |
LONG VARCHAR | CHARACTER | 1 to 32000000 | X | X | Long variable-length character string |
DATE/TIME DATA TYPES | |||||
DATE | DATE | 8 | X | X |
Represents a month, day, and year
|
DATETIME | DATETIME | 8 | X | X |
Represents a date and time with or without timezone (synonym for TIMESTAMP)
|
SMALLDATETIME | DATETIME | 8 | X | X |
Represents a date and time with or without timezone (synonym for TIMESTAMP)
|
TIME | TIME | 8 | X | X |
Represents a time of day without timezone
|
TIME WITH TIMEZONE | TIME | 8 | X | X |
Represents a time of day with timezone
|
TIMESTAMP | DATETIME | 8 | X | X |
Represents a date and time without timezone
|
TIMESTAMP WITH TIMEZONE | DATETIME | 8 | X | X |
Represents a date and time with timezone
|
INTERVAL | INTERVAL | 8 | X | X |
Measures the difference between two points in time
|
APPROXIMATE NUMERIC DATA TYPES | |||||
DOUBLE PRECISION | NUMERIC | 8 | X | X |
Signed 64-bit IEEE floating point number, requiring 8 bytes of storage
|
FLOAT | NUMERIC | 8 | X | X | Signed 64-bit IEEE floating point number, requiring 8 bytes of storage |
FLOAT(n) | NUMERIC | 8 | X | X | Signed 64-bit IEEE floating point number, requiring 8 bytes of storage |
FLOAT8 | NUMERIC | 8 | X | X | Signed 64-bit IEEE floating point number, requiring 8 bytes of storage |
REAL | NUMERIC | 8 | X | X | Signed 64-bit IEEE floating point number, requiring 8 bytes of storage |
EXACT NUMERIC DATA TYPES | |||||
INTEGER | NUMERIC | 8 | X | X |
Signed 64-bit integer, requiring 8 bytes NULLS FIRST of storage
|
INT | NUMERIC | 8 | X | X | Signed 64-bit integer, requiring 8 bytes NULLS FIRST of storage |
BIGINT | NUMERIC | 8 | X | X | Signed 64-bit integer, requiring 8 bytes NULLS FIRST of storage |
INT8 | NUMERIC | 8 | X | X | Signed 64-bit integer, requiring 8 bytes NULLS FIRST of storage |
SMALLINT | NUMERIC | 8 | X | X | Signed 64-bit integer, requiring 8 bytes NULLS FIRST of storage |
TINYINT | NUMERIC | 8 | X | X | Signed 64-bit integer, requiring 8 bytes NULLS FIRST of storage |
DECIMAL | NUMERIC | 8+ | X | X |
8 bytes for the first 18 digits of precision, plus 8 bytes for each additional 19 digits
|
NUMERIC | NUMERIC | 8+ | X | X | 8 bytes for the first 18 digits of precision, plus 8 bytes for each additional 19 digits |
NUMBER | NUMERIC | 8+ | X | X | 8 bytes for the first 18 digits of precision, plus 8 bytes for each additional 19 digits |
MONEY | NUMERIC | 8+ | X | X | 8 bytes for the first 18 digits of precision, plus 8 bytes for each additional 19 digits |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017