mapping of SQL Server driver to the JDBC data types
Data Types
lists the data types supported by the SQL Server driver and how they are mapped to the JDBC data types.
Table 3-2. SQL Server 2000 Data Types
SQL Server Data Type
JDBC Data Type
bigint
BIGINT
bigint identity
BIGINT
binary
BINARY
bit
BIT
char
CHAR
datetime
TIMESTAMP
decimal
DECIMAL
decimal() identity
DECIMAL
float
FLOAT
image
LONGVARBINARY
int
INTEGER
int identity
INTEGER
money
DECIMAL
nchar
CHAR
ntext
LONGVARCHAR
numeric
NUMERIC
numeric() identity
NUMERIC
nvarchar
VARCHAR
real
REAL
smalldatetime
TIMESTAMP
smallint
SMALLINT
smallint identity
SMALLINT
smallmoney
DECIMAL
sql_variant
VARCHAR
sysname
VARCHAR
text
LONGVARCHAR
timestamp
BINARY
tinyint
TINYINT
tinyint identity
TINYINT
uniqueidentifier
CHAR
varbinary
VARBINARY
varchar
VARCHAR