5/13/2012

The corresponding values types of SQL 2008, JDBC and Java


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