TEXT and BYTE (LOB) types
Informix®
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.
SQLite
SQLite 3 provides the TEXT and BLOB native data types for large
objects storage.
Solution
The SQLite database interface can convert BDL TEXT data to SQLite
TEXT and BYTE data to SQLite BLOB.
The
TEXT and
BYTE types translation can be controlled with the following FGLPROFILE
entries:dbi.database.dsname.ifxemul.datatype.text = { true | false }
dbi.database.dsname.ifxemul.datatype.byte = { true | false }