Data types
- Last Updated: March 11, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Microsoft SQL Server 6.0
- Documentation
The following table lists supported data types supported and how they are mapped to JDBC data types.
| Microsoft SQL Server Data Type | JDBC Data Type |
|---|---|
| bigint | BIGINT |
| bigint identity | BIGINT |
| binary | BINARY |
| bit | BIT |
| char | CHAR |
| date | DATE |
| datetime | TIMESTAMP |
| datetime2 | TIMESTAMP |
| datetimeoffset1 | VARCHAR or TIMESTAMP |
| decimal | DECIMAL |
| decimal() identity2 | DECIMAL |
| float | FLOAT |
| image3 | LONGVARBINARY |
| int | INTEGER |
| int identity | INTEGER |
| money | DECIMAL |
| nchar | NCHAR |
| ntext4 | LONGNVARCHAR |
| numeric | NUMERIC |
| numeric() identity5 | NUMERIC |
| nvarchar | NVARCHAR |
| nvarchar(max) | LONGNVARCHAR |
| real | REAL |
| smalldatetime | TIMESTAMP |
| smallint | SMALLINT |
| smallint identity6 | SMALLINT |
| smallmoney | DECIMAL |
| sql_variant7 | VARCHAR |
| sysname | VARCHAR |
| text8 | LONGVARCHAR |
| time9 | TIME or TIMESTAMP |
| timestamp | BINARY |
| tinyint | TINYINT |
| tinyint identity10 | TINYINT |
| uniqueidentifier | CHAR |
| varbinary | VARBINARY |
| varbinary(max) | LONGVARBINARY |
| varchar | VARCHAR |
| varchar(max) | LONGVARCHAR |
| xml11, 12 | SQLXML |
1 When FetchTSWTZasTimestamp=false (default), this
data type is mapped to the JDBC VARCHAR data type; when
FetchTSWTZasTimestamp=true, it is mapped to the JDBC TIMESTAMP data
type.
2 Not supported for
Microsoft Azure Synapse Analytics and Microsoft Analytics Platform
System.
3 Not
supported for Microsoft Azure Synapse Analytics and Microsoft
Analytics Platform System.
4 Not
supported for Microsoft Azure Synapse Analytics and Microsoft
Analytics Platform System.
5 Not supported for Microsoft Azure
Synapse Analytics and Microsoft Analytics Platform
System.
6 Not supported for Microsoft Azure
Synapse Analytics and Microsoft Analytics Platform
System.
7 Not supported for Microsoft Azure
Synapse Analytics and Microsoft Analytics Platform
System.
8 Not
supported for Microsoft Azure Synapse Analytics and Microsoft
Analytics Platform System.
9 When FetchTWFSasTime=true,
this data type is mapped to the JDBC TIME data type. When FetchTWFSasTime=false (the default),
this data type is mapped to the JDBC TIMESTAMP data type.
10 Not supported for Microsoft Azure
Synapse Analytics and Microsoft Analytics Platform
System.
11 Not
supported for Microsoft Azure Synapse Analytics and Microsoft
Analytics Platform System.
12 The XMLDescribeType property
overrides the mappings for XML data.