BLOB
byte[]
BOOLEAN
boolean
BYTE
CHAR, CHARACTER
String
CHARACTER VARYING
CLOB
DATE
java.sql.Date
DATETIME
java.sql.Timestamp
DECIMAL, NUMERIC, DEC
java.math.BigDecimal
FLOAT, DOUBLE PRECISION
double
INT8
long
INTEGER, INT
int
INTERVAL
IfxIntervalDF, IfxIntervalYM *
LVARCHAR
MONEY
NCHAR, NVARCHAR
SERIAL
SERIAL8
SMALLFLOAT
SMALLINT
short
TEXT
VARCHAR
* IfxIntervalYM and IfxIntervalDF are Informix extensions to JDBC 2.0.
You must also use compatible Java types for host variables that are arguments to SQL operations. This table shows valid conversions from Java types to SQL types.
DECIMAL
FLOAT
float
INT
CHAR
java.sql.Time
com.informix.jdbc.IfxIntervalDF
com.informix.jdbc.IfxIntervalYM
null
NULL