Data Type Aliases

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