JDBC data types (Java. SQL. types) and Java data types corresponding to SQL Server Data Types

SQL Server types	JDBC types (Java. SQL. types)	Java language types
Bigint	Bigint	Long
Timestamp Binary Uniqueidentifier	Binary	Byte []
Bit	Bit	Boolean
Charnchar	Char	String
N/	Date	Java. SQL. Date
Decimal Money Smallmoney	Decimal	Java. Math. bigdecimal
N/	Double	Double
Float	Float	Double
Int	Integer	Int
Image	Longvarbinary	Byte []
Text Ntext	Longvarchar	String
N/	Null	N/
Numeric	Numeric	Java. Math. bigdecimal
N/	Other	N/
Real	Real	Float
Smallint Tinyint	Smallint	Short
N/	Time	N/
Datetime Smalldatetime	Timestamp	Java. SQL. Timestamp
N/	Tinyint	Byte []
Varbinary	Varbinary	Byte []
Varchar Nvarchar	Varchar	String