| title | titleSuffix | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
|---|---|---|---|---|---|---|---|---|---|
Java data types |
SQL Server Language Extensions |
Map data types from Java to SQL Server for input and output data structures, and for input parameters on the sp_execute_external_script. |
rwestMSFT |
randolphwest |
04/29/2024 |
sql |
language-extensions |
conceptual |
>=sql-server-ver15 || >=sql-server-linux-ver15 |
[!INCLUDE sqlserver2019-and-later]
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 |