Jdbc is useful for SqlServer and java data type ing tables)

MicrosoftSQLServerJDBCDriver converts the SQLServer data type to a format that can be understood by the Java programming language using the JDBC basic data type, or vice versa. Since MicrosoftSQLServerJDBCDriver2.0, The JDBC driver supports the JDBC4.0API, which includes the SQLXML data type and

Microsoft SQL Server JDBC Driver converts the SQL Server data type to a format that can be understood by the Java programming language using the basic JDBC data type, or vice versa. Since Microsoft SQL Server JDBC Driver 2.0, the JDBC Driver provides support for the JDBC 4.0 API, which includes the SQLXML data type and

Microsoft SQL Server JDBC Driver converts the SQL Server data type to a format that can be understood by the Java programming language using the basic JDBC data type, or vice versa. Since Microsoft SQL Server JDBC Driver 2.0, the JDBC Driver provides support for the JDBC 4.0 API, which includesSQLXMLData Type and National (Unicode) data type, suchNCHAR,NVARCHAR,LONGNVARCHARAndNCLOB.

Data Type ing

The following table lists the default mappings between basic SQL Server, JDBC, and Java programming language data types:

SQL Server Type	JDBC Type (java. SQL. Types)	Java language type
Bigint	BIGINT	Long
Timestamp Binary	BINARY	Byte []
Bit	BIT	Boolean
Char	CHAR	String
Decimal Money Smallmoney	DECIMAL	Java. math. BigDecimal
Float	DOUBLE	Double
Int	INTEGER	Int
Image Varbinary (max)	LONGVARBINARY	Byte []
Varchar (max) Text	LONGVARCHAR	String
Nchar	CHAR NCHAR (Java SE 6.0)	String
Nvarchar	VARCHAR NVARCHAR (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 SQLXML (Java SE 6.0)	String SQLXML
Time	TIME (1)	Java. SQL. Time (1)
Date	DATE	Java. SQL. Date
Datetime2	TIMESTAMP	Java. SQL. Timestamp
Datetimeoffset (2)	Microsoft. SQL. Types. DATETIMEOFFSET	Microsoft. SQL. DateTimeOffset