Product specifications

Data foundation data type
Informix JDBC data type
It can be mapped to:
• DATE if the Informix data type follows the pattern DATE
TIME\\s+(HOUR|MINUTE|SEC
OND)\\s+TO\\s+(HOUR|MINUTE|SECOND)
• TIME if the Informix data type follows the pattern DATE
TIME\\s+(YEAR|MONTH|DAY)\\s+TO\\s+(YEAR|MONTH|DAY)
• TIMESTAMP in the other cases
TIMESTAMP
SMALLINTBOOLEAN
MS SQL Server
The following table lists the data types that could show up in results when the user queries an MS SQL
Server database through JDBC, and their equivalent in data foundations. The data type mapping also
depends on the SQL type name associated with the network layer data type. These data types overwrite
the generic ones.
Data foundation data type
SQL type name
MS SQL Server JDBC data
type
VARCHARany other value than "xml"LONGVARCHAR
XMLxmlLONGVARCHAR
Oracle
The following table lists the data types that could show up in results when the user queries an Oracle
database through JDBC, and their equivalent in data foundations. The data type mapping also depends
on the SQL type name associated with the network layer data type. These data types overwrite the
generic ones.
Data foundation data type
SQL type nameOracle JDBC data type
LONGVARBINARYany valueBFILE
LONGVARBINARYBFILEany value
TIMESTAMPany valueDATE
2012-03-15181
Data type conversion reference