Updated on 2022-08-16 GMT+08:00

Data Types Supported by Column-Store Tables

Table 1 lists the data types supported by column-store tables.

Table 1 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

name

64

No

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