#
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 |