TEXT and BYTE (LOB) types


Informix provides the TEXT, BYTE, CLOB and BLOB data types to store very large texts or binary data.

Legacy Informix 4GL applications typically use the TEXT and BYTE types.

Genero BDL does not support the Informix CLOB and BLOB types.


Netezza does not support large objects in the database.


If your application need to store large objects with TEXT and BYTE data types, you cannot use a Netezza server.