Supported SQL data types

warning

This connector is now in Deprecated status. It is no longer available for new users and is not actively maintained. We will provide a minimum six-month notice before its retirement. We recommend upgrading to the newer supported version of this connector.

The following SQL data types are supported by the SQL connector

Supported SQL data types

Data type	Supported in MySQL?	Supported in PostgreSQL?	Supported in SQL Server?
BIGINT	✅ Supported	✅ Supported	✅ Supported
BLOB	✅ Supported	✅ Supported	✅ Supported
BOOLEAN	✅ Supported	✅ Supported	✅ Supported
CHAR	✅ Supported	✅ Supported	✅ Supported
CLOB	✅ Supported	✅ Supported	✅ Supported
DATE	✅ Supported	✅ Supported	✅ Supported
DATETIMEOFFSET	❌ Unsupported	❌ Unsupported	✅ Supported
DECIMAL	✅ Supported	✅ Supported	✅ Supported
DOUBLE	✅ Supported	✅ Supported	✅ Supported
FLOAT	✅ Supported	✅ Supported	✅ Supported
INTEGER	✅ Supported	✅ Supported	✅ Supported
LONGVARCHAR	✅ Supported	✅ Supported	✅ Supported
LONGNVARCHAR	✅ Supported	✅ Supported	✅ Supported
NCHAR	✅ Supported	✅ Supported	✅ Supported
NVARCHAR	✅ Supported	✅ Supported	✅ Supported
NUMERIC	✅ Supported	✅ Supported	✅ Supported
REAL	✅ Supported	✅ Supported	✅ Supported
SMALLINT	✅ Supported	✅ Supported	✅ Supported
TIMESTAMP	❌ Unsupported	✅ Supported	❌ Unsupported
TINYINT	✅ Supported	✅ Supported	✅ Supported
UUID	❌ Unsupported	✅ Supported	❌ Unsupported
VARCHAR	✅ Supported	✅ Supported	✅ Supported