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 |