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 |