SQL Server
|
JDBC
|
Java Language
|
bigint
|
BIGINT
|
long
|
timestamp
binary
|
BINARY
|
byte[]
|
bit
|
BIT
|
boolean
|
char
|
CHAR
|
String
|
decimal
money
smallmoney
|
DECIMAL
|
Java.math.BigDecimal
|
float
|
BOUBLE
|
double
|
int
|
INTEGER
|
int
|
image
varbinary(max)
|
LONGVARBINARY
|
byte[]
|
varchar(max)
text
|
LONGVARCHAR
|
String
|
nchar
|
CHAR
NCHAR(Java SE 6.0)
|
String
|
nvarchar(max)
ntext
|
LONGVARCHAR
LONGNVARCHAR(Java SE 6.0)
|
String
|
numeric
|
NUMERIC
|
Java.math.BigDecimal
|
real
|
REAL
|
float
|
smallint
|
SMALLINT
|
short
|
datetime
smalldatetime
|
TIMESTAMP
|
Java.sql.Timestamp
|
varbinary
udt
|
VARBINARY
|
byte[]
|
varchar
|
VARCHAR
|
String
|
tinyint
|
TINYINT
|
short
|
uniqueidentifier
|
CHAR
|
String
|
xml
|
LONGVARCHAR
SQLXNL(Java SE 6.0)
|
String
SQLXML
|
Reference http://msdn.microsoft.com/en-us/library/ms378878%28v=SQL.100%29.aspx