For compatibility reasons, Exasol has implemented several aliases. The following table provides you with the list of aliases.
Alias | Exasol Type Equivalent | Note |
---|---|---|
BIGINT | DECIMAL(36,0) | |
BOOL | BOOLEAN | |
CHAR | CHAR(1) | |
CHAR VARYING(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |
CHARACTER | CHAR(1) | |
CHARACTER LARGE OBJECT | VARCHAR(2000000) | |
CHARACTER LARGE OBJECT(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |
CHARACTER VARYING(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |
CLOB | VARCHAR(2000000) | |
CLOB(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |
DEC | DECIMAL(18,0) | |
DEC(p) | DECIMAL(p,0) | 1 ≤ p ≤ 36 |
DEC(p,s) | DECIMAL(p,s) | s ≤ p ≤ 36 p ≥ 1; s ≥ 0 |
DECIMAL | DECIMAL(18,0) | |
DECIMAL(p) | DECIMAL(p,0) | 1 ≤ p ≤ 36 |
DOUBLE | DOUBLE PRECISION | |
HASHTYPE | HASHTYPE (16 BYTE) | |
FLOAT | DOUBLE PRECISION | |
INT | DECIMAL(18,0) | |
INTEGER | DECIMAL(18,0) | |
LONG VARCHAR | VARCHAR(2000000) | |
NCHAR(n) | CHAR(n) | |
NUMBER | DOUBLE PRECISION | Possible loss in precision |
NUMBER(p) | DECIMAL(p,0) | 1 ≤ p ≤ 36 |
NUMBER(p,s) | DECIMAL(p,s) | s ≤ p ≤ 36 p ≥ 1; s ≥ 0 |
NUMERIC | DECIMAL(18,0) | |
NUMERIC(p) | DECIMAL(p,0) | 1 ≤ p ≤ 36 |
NUMERIC(p,s) | DECIMAL(p,s) | s ≤ p ≤ 36 p ≥ 1; s ≥ 0 |
NVARCHAR(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |
NVARCHAR2(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |
REAL | DOUBLE PRECISION | |
SHORTINT | DECIMAL(9,0) | |
SMALLINT | DECIMAL(9,0) | |
TIMESTAMP | TIMESTAMP(3) | |
TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMP(3) WITH LOCAL TIME ZONE | |
TINYINT | DECIMAL(3,0) | |
VARCHAR2(n) | VARCHAR(n) | 1 ≤ n ≤ 2,000,000 |