Help Center > > Developer Guide> SQL Reference> Data Types> Data Types Supported by Column-Store Tables

Data Types Supported by Column-Store Tables

Updated at: Jul 15, 2020 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel