Java and SQL Server supported data types

Applies to: SQL Server 2019 (15.x) and later versions

This article maps SQL Server data types to Java data types for data structures and parameters on sp_execute_external_script.

The following SQL and Java data types are currently supported for input/output data sets and input/output parameters.

SQL Server data type	Java data type	Comment
bit	boolean
tinyint	short
smallint	short
int	int
real	float
bigint	long
float	double
nchar(n)	String
nvarchar(n)	String
binary(n)	byte[]
varbinary(n)	byte[]
nvarchar(max)	String
varbinary(max)	byte[]
uniqueidentifier	String
char(n)	String	Only UTF-8 Strings supported
varchar(n)	String	Only UTF-8 Strings supported
varchar(max)	String	Only UTF-8 Strings supported
date	java.sql.date
numeric	java.math.BigDecimal
decimal	java.math.BigDecimal
money	java.math.BigDecimal
smallmoney	java.math.BigDecimal
smalldatetime	java.sql.timestamp
datetime	java.sql.timestamp
datetime2	java.sql.timestamp

Related content

• How to call the Java runtime in SQL Server Language Extensions