[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
java.sql.Types
Table 6-3 shows the mapping of java.sql.Types to SQL-J types.
Table 6-3 Mapping of java.sql.Types to SQL-J Types
java.sql.Types |
SQL-J Types |
BIGINT
|
LONGINT
|
BINARY
|
BIT
|
BIT
|
BOOLEAN
|
CHAR
|
CHAR
|
DATE
|
DATE
|
DECIMAL
|
DECIMAL
|
DOUBLE
|
DOUBLE PRECISION
|
FLOAT
|
DOUBLE PRECISION1
|
INTEGER
|
INTEGER
|
LONGVARBINARY
|
LONG VARBINARY
|
LONGVARCHAR
|
LONG VARCHAR
|
NULL
|
Not a data type; always a value of a particular type
|
NUMERIC
|
DECIMAL
|
OTHER
|
Java classes
|
REAL
|
REAL
|
SMALLINT
|
SMALLINT
|
TIME
|
TIME
|
TIMESTAMP
|
TIMESTAMP
|
TINYINT
|
TINYINT
|
VARBINARY
|
BIT VARYING
|
VARCHAR
|
VARCHAR
|
1
Values can be passed in using the FLOAT type code; however, these are stored as DOUBLE PRECISION values, and so always have the type code DOUBLE when retrieved.
|
|