skip to main content
Welcome to the Progress DataDirect for JDBC for SQL Server: Version 6.0.0 : Data types
  

Try DataDirect Drivers Now

Data types

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.

* getTypeInfo