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 |
