Supported SQL data types
Updated 31 July 2025
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 |
