Mapping an SQL Data Type to a JADE Primitive Type

The following table lists the ANSI SQL data types and the JADE primitive types to which they are mapped by default.

ANSI SQL Data Type	JADE Primitive Type
BINARY, VARBINARY, LONGVARBINARY	Binary
BIT	Boolean
CHAR(1), TINYINT	Character
CHAR, VARCHAR, LONGVARCHAR	String
DECIMAL and NUMERIC (precision and scale factor)	Decimal (precision and scale factor)
REAL, FLOAT, DOUBLE	Real
INTEGER, SMALLINT	Integer
BIGINT (64-bit integer)	Decimal [20, 0]
DATE	Date
TIME	Time
TIMESTAMP	TimeStamp

Some external databases may have restrictions in the use of specific SQL data types, which the user may need to be aware of when changing data in those databases.