skip to main content
DataDirect Connect Drivers : Informix Driver : Data Types
  
Data Types
The following table lists the data types supported by the Informix driver and how they are mapped to the JDBC data types.
Table 34. Informix Data Types
Informix Data Type
JDBC Data Type
BLOB
BLOB
BOOLEAN
BIT
BYTE
LONGVARBINARY
CHAR
CHAR
CLOB
CLOB
DATE
DATE
DATETIME HOUR TO SECOND
TIME
DATETIME YEAR TO DAY
DATE
DATETIME YEAR TO FRACTION(5)
TIMESTAMP
DATETIME YEAR TO SECOND
TIMESTAMP
DECIMAL
DECIMAL
FLOAT
FLOAT
INT8
BIGINT
INTEGER
INTEGER
LVARCHAR
VARCHAR
MONEY
DECIMAL
NCHAR
CHAR or NCHAR 1
NVARCHAR
VARCHAR or NVARCHAR 2
SERIAL
INTEGER
SERIAL8
BIGINT
SMALLFLOAT
REAL
SMALLINT
SMALLINT
TEXT
LONGVARCHAR
VARCHAR
VARCHAR

1 When JDBCBehavior=0, the data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.

2 When JDBCBehavior=0, the data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.

Refer to "getTypeInfo()" in the DataDirect Connect Series for JDBC Reference for more information about data types.