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 |
京公网安备 11010802021500号