Data Types

The Starburst ODBC Driver supports many common SQL data types.

The table below lists the supported data types.

Supported SQL types
ARRAY Note: The connector casts this type to VARCHAR.	REAL Note: Only supported in Starburst 0.152t and later.
BIGINT	ROW Note: The connector casts this type to VARCHAR.
BOOLEAN	SMALLINT
CHAR(x) Note: WCHAR is used instead if the Use Unicode SQL Character Types configuration option (the `UseUnicodeSqlCharacterTypes` key) is enabled.	TIME
CHAR(x) Note: WCHAR is used instead if the Use Unicode SQL Character Types configuration option (the `UseUnicodeSqlCharacterTypes` key) is enabled.	TIME(P)
DATE	TIME WITH TIME ZONE
VARCHAR	TIME(P) WITH TIME ZONE
DECIMAL	TIMESTAMP
DECIMAL	TIMESTAMP(P)
DOUBLE	TIMESTAMP WITH TIME ZONE
FLOAT Note: Deprecated in Starburst 0.152t and later.	TINYINT
INTEGER	VARBINARY
INTERVAL DAY TO SECOND	VARCHAR (fixed length)
INTERVAL YEAR TO MONTH	VARCHAR (variable length)
JSON Note: The connector casts this type to VARCHAR.	VARCHAR(x)
MAP Note: The connector casts this type to VARCHAR.	Note: For all VARCHAR types, WVARCHAR is used instead if the Use Unicode SQL Character Types configuration option (the `UseUnicodeSqlCharacterTypes` key) is enabled.