Data Types Supported by Column-Store Tables¶
Table 1 lists the data types supported by column-store tables.
Category | Data Type | Length | Supported |
---|---|---|---|
Numeric types | smallint | 2 | Yes |
integer | 4 | Yes | |
bigint | 8 | Yes | |
decimal | Variable length | Yes | |
numeric | Variable length | Yes | |
real | 4 | Yes | |
double precision | 8 | Yes | |
smallserial | 2 | Yes | |
serial | 4 | Yes | |
bigserial | 8 | Yes | |
Monetary types | money | 8 | Yes |
Character types | character varying(n), varchar(n) | Variable length | Yes |
character(n), char(n) | n | Yes | |
character, char | 1 | Yes | |
text | Variable length | Yes | |
nvarchar2 | Variable length | Yes | |
Date/time types | timestamp with time zone | 8 | Yes |
timestamp without time zone | 8 | Yes | |
date | 4 | Yes | |
time without time zone | 8 | Yes | |
time with time zone | 12 | Yes | |
interval | 16 | Yes | |
Large objects | clob | Variable length | Yes |
blob | Variable length | No | |
Others | ... | ... | No |