Supported SQL Server data types

Datatype Generic SQL datatype Java datatype for modification

BIGINT

BIGINT

java.math.BigDecimal

BINARY

CLOB

java.lang.byte[]

BIT

BIT

java.math.BigDecimal

BLOB

BLOB

java.sql.Blob

CHAR

CHAR

java.lang.String

CLOB

CLOB

java.sql.Clob

DATETIME2

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DATETIMEOFFSET

TIMESTAMP_WITH_TIMEZONE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DATETIME

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DATE

DATE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DECIMAL

DECIMAL

java.math.BigDecimal

GEOGRAPHY

GEOGRAPHY

com.microsoft.sqlserver.jdbc.Geography

IMAGE

BLOB

java.sql.Blob

INT

INTEGER

java.math.BigDecimal

MONEY

DECIMAL

java.math.BigDecimal

NCHAR

NCHAR

java.lang.String

NCLOB

CLOB

java.sql.Clob

NTEXT

CLOB

java.sql.Clob

NUMERIC

DECIMAL

java.math.BigDecimal

NVARCHAR

NVARCHAR

java.lang.String

REAL

FLOAT

java.math.BigDecimal

SMALLDATETIME

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

SMALLINT

SMALLINT

java.math.BigDecimal

SMALLMONEY

DECIMAL

java.math.BigDecimal

SYSNAME

SYSNAME

java.lang.String

TEXT

CLOB

java.sql.Clob

TIMESTAMP

ROWID

java.lang.byte[]

TIME

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TINYINT

TINYINT

java.math.BigDecimal

UNIQUEIDENTIFIER

UUID

java.lang.String

VARBINARY

CLOB

java.lang.byte[]

VARCHAR

VARCHAR

java.lang.String

XML

SQLXML

java.sql.Clob