Programming Blog

Java SQL Data Types

Mapping Java Data types to SQL Data Types in your java program.

While developing database interface for the your java application, it is often required to map Java Data Types to SQL Data types. In this post I will explain you how you can map it.

The following table shows you how to map SQL data types to Java Data types.

SQL data type	Java data type
	Simply mappable	Object mappable
CHARACTER		String
VARCHAR		String
LONGVARCHAR		String
NUMERIC		java.math.BigDecimal
DECIMAL		java.math.BigDecimal
BIT	boolean	Boolean
TINYINT	byte	Integer
SMALLINT	short	Integer
INTEGER	int	Integer
BIGINT	long	Long
REAL	float	Float
FLOAT	double	Double
DOUBLE PRECISION	double	Double
BINARY		byte[]
VARBINARY		byte[]
LONGVARBINARY		byte[]
DATE		java.sql.Date
TIME		java.sql.Time
TIMESTAMP		java.sql.Timestamp

Learn Java Programming in detail.

Thanks