Supported data types

This section lists the server data types and the interfaces supported for them.

Tip: Objects that are BLOB and CLOB objects implemented as part of the HCL Informix® Object Interface for C++ library return the textual value of the smart large object handle through the ITValue::Printable method and set it through ITValue::FromPrintable.

Simple large objects (TEXT and BYTE types) are represented on the client as data in RAM. Use the offset operator [] in queries to limit the amount of data retrieved by the client. To update a simple large object in the server, pass the value object that encapsulates the simple large object data as a prepared statement parameter.

Table 1. Data types and supported interfaces
Data type	ITEssential interface	ITValue interface	ITRow interface	ITConversions interface	ITLargeObject interface	ITSet interface
blob*	X	X			X
boolean*	X	X		X
byte	X	X
char	X	X		X
character	X	X		X
char1	X	X		X
cXob*	X	X			X
date	X	X
datetime	X	X
decimal	X	X		X
double precision	X	X		X
int8*	X	X		X
integer	X	X		X
interval day to second	X	X
interval year to month	X	X
money	X	X		X
numeric	X	X		X
real	X	X		X
smallint	X	X		X
text	X	X
collection* **	X	X				X
row* **	X	X	X
ITQuery::ExecToSet result set **	X	X				X

* Supported only by HCL Informix

** Constructed type

Table 2. More supported interfaces
Server base type	ITDateTime	ITContainer	ITErrorInfo	ITDatum
blob*			X	X
boolean*				X
byte				X
char				X
character				X
char1				X
cXob*			X	X
date	X			X
datetime	X			X
decimal				X
double precision				X
int8*				X
integer				X
interval day to second	X			X
interval year to month	X			X
money				X
numeric				X
real				X
smallint				X
text				X
collection* **				X
row* **		X		X
ITQuery::ExecToSet result set **

* Supported only by HCL Informix

** Constructed type