MAPPING SQL TYPES TO JAVA/DATABASE (Updated For DbGen 1.2)
==========================================================

SQL		Java		Oracle		Sybase		Access		mSQL
-------------------------------------------------------------------------------------------
CHAR		String		CHAR(n)		CHAR(n)		TEXT(n)		char(n)
VARCHAR		String		VARCHAR2(n)	VARCHAR(n)	TEXT(n)		char(n)
LONGVARCHAR	String		LONG		TEXT		MEMO		text(n)
NUMERIC		BigDecimal	NUMBER(p,s)	NUMERIC(p,s)	CURRENCY	real*
DECIMAL		BigDecimal	NUMBER(p,s)	DECIMAL(p,s)	CURRENCY	real*
BIT		boolean		NUMBER(1)	BIT		BIT		int
TINYINT		byte		NUMBER(4)	TINYINT		BYTE		int
SMALLINT	short		NUMBER(6)	SMALLINT	SHORT		int
INTEGER		int		NUMBER(12)	INT		LONG		int
BIGINT		long		NUMBER(38)	N/A		N/A		N/A
REAL		float		NUMBER		REAL		SINGLE		real
FLOAT		double		NUMBER		FLOAT		DOUBLE		real
DOUBLE		double		NUMBER		DOUBLE PRECISION DOUBLE		real
BINARY		byte[]		RAW(n)		BINARY(n)	N/A		char(n)
VARBINARY	byte[]		RAW(n)		VARBINARY(n)	N/A		char(n)
LONGVARBINARY	byte[]		LONG RAW	IMAGE		N/A		text(n)
DATE		Date		DATE		DATETIME	DATETIME	char(12)/char(21)**
TIME		Time		DATE		DATETIME	DATETIME	char(9)/char(21)**
TIMESTAMP	Timestamp	DATE		DATETIME	DATETIME	char(21)**

Notes:
------
+  Parameters Defintion: p = Precision, s = Scale, n = Number
*  In mSQL-JDBC Driver, numerics are extracted from "real" value.
** In mSQL-JDBC DRiver, date information are extracted from "long" value (char(21)), or
   in "dd-MMM-yyyy" format and "hh:mm:ss" for date and time respectively.  For timestamp,
   always use a "long" value.