Built-In Data Types
HCL OneDB™ supports
the following built-in data types.
| Category | Data Types |
|---|---|
| Character | CHAR, CHARACTER VARYING, LVARCHAR, NCHAR, NVARCHAR, VARCHAR, IDSSECURITYLABEL |
| Large-object | Simple-large-object types: BYTE, TEXT Smart-large-object types: BLOB, CLOB |
| Logical | BOOLEAN |
| Multirepresentational | BSON and JSON built-in opaque data types |
| Numeric | BIGINT, BIGSERIAL, DECIMAL, FLOAT, INT8, INTEGER, MONEY, SERIAL, SERIAL8, SMALLFLOAT, SMALLINT |
| Time | DATE, DATETIME, INTERVAL |