Exasol has implemented the following data type aliases to provide compatibility:
Numeric data type aliases
For more details about the Exasol data types, see Numeric data types.
| Alias | Exasol data type equivalent |
|---|---|
BIGINT
|
DECIMAL(36,0)
|
DEC
|
DECIMAL(18,0)
|
DEC(p)
|
DECIMAL(p,0)
|
DEC(p,s)
|
DECIMAL(p,s)
|
DECIMAL
|
DECIMAL(18,0)
|
DECIMAL(p)
|
DECIMAL(p,0)
|
DOUBLE
|
DOUBLE PRECISION
|
FLOAT
|
DOUBLE PRECISION
|
INT
|
DECIMAL(18,0)
|
INTEGER
|
DECIMAL(18,0)
|
NUMBER
|
DOUBLE PRECISION
|
NUMBER(p)
|
DECIMAL(p,0)
|
NUMBER(p,s)
|
DECIMAL(p,s)
|
NUMERIC
|
DECIMAL(18,0)
|
NUMERIC(p)
|
DECIMAL(p,0)
|
NUMERIC(p,s)
|
DECIMAL(p,s)
|
REAL
|
DOUBLE PRECISION
|
SHORTINT
|
DECIMAL(9,0)
|
SMALLINT
|
DECIMAL(9,0)
|
TINYINT
|
DECIMAL(3,0)
|
String data type aliases
For more details about the Exasol data types, see String data types.
| Alias | Exasol data type equivalent |
|---|---|
CHAR
|
CHAR(1)
|
CHAR VARYING(n)
|
VARCHAR(n)
|
CHARACTER
|
CHAR(1)
|
CHARACTER LARGE OBJECT
|
VARCHAR(2000000)
|
CHARACTER LARGE OBJECT(n)
|
VARCHAR(n)
|
CHARACTER VARYING(n)
|
VARCHAR(n)
|
CLOB
|
VARCHAR(2000000)
|
CLOB(n)
|
VARCHAR(n)
|
LONG VARCHAR
|
VARCHAR(2000000)
|
NCHAR
|
CHAR(1)
|
NCHAR(n)
|
CHAR(n)
|
NVARCHAR(n)
|
VARCHAR(n)
|
NVARCHAR2(n)
|
VARCHAR(n)
|
VARCHAR2(n)
|
VARCHAR(n)
|
Date and time data type aliases
For more details about the Exasol data types, see Date and time data types.
| Alias | Exasol data type equivalent |
|---|---|
TIMESTAMP
|
TIMESTAMP(3)
|
TIMESTAMP WITH LOCAL TIME ZONE
|
TIMESTAMP(3) WITH LOCAL TIME ZONE
|
TIMESTAMP WITHOUT TIME ZONE
|
TIMESTAMP(3)
|
TIMESTAMP(p) WITHOUT TIME ZONE
|
TIMESTAMP(p)
|
Interval data type aliases
For more details about the Exasol data types, see Interval data types.
| Alias | Exasol data type equivalent |
|---|---|
INTERVAL DAY TO SECOND
|
INTERVAL DAY(2) TO SECOND(3)
|
INTERVAL DAY TO SECOND(fsp) |
INTERVAL DAY(2) TO SECOND(fsp)
|
INTERVAL DAY(lfp) TO SECOND
|
INTERVAL DAY(lfp) TO SECOND(3)
|
INTERVAL YEAR TO MONTH
|
INTERVAL YEAR(2) TO MONTH
|
Boolean data type alias
For more details about the Exasol data type, see Boolean data type.
| Alias | Exasol data type equivalent |
|---|---|
BOOL
|
BOOLEAN
|
Geospatial data type alias
For more details about the Exasol data type, see Geospatial data type.
| Alias | Exasol data type equivalent |
|---|---|
GEOMETRY
|
GEOMETRY(0)
|
HASHTYPE data type aliases
For more details about the Exasol data type, see HASHTYPE data type.
| Alias | Exasol data type equivalent |
|---|---|
HASHTYPE
|
HASHTYPE(16 BYTE)
|
HASHTYPE(m BIT)
|
|
