X100 Supported Data Types
Data types that can be used in X100 tables are limited to the following:
CHAR
VARCHAR
NCHAR
NVARCHAR
INTEGER1 (TINYINT)
INTEGER2 (SMALLINT)
INTEGER4 (INTEGER)
INTEGER8 (BIGINT)
DECIMAL
FLOAT
FLOAT4
ANSIDATE
TIME WITHOUT TIME ZONE
TIME WITH TIME ZONE
TIME WITH LOCAL TIME ZONE
TIMESTAMP WITHOUT TIME ZONE
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
MONEY
IPV4
IPV6
UUID
BOOLEAN
Last modified date: 04/03/2024