The following table lists supported data types supported and how they are mapped to JDBC data types.

Table 1. Microsoft SQL Server 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.