Large OBject (LOB) types

IBM® Informix® and Genero support the TEXT and BYTE types to store large objects: TEXT is used to store large text data, while BYTE is used to store large binary data like images or sound.

SQLite 3 provides TEXT and BLOB native data types for large objects storage.

Solution

The SQLite database interface can convert BDL TEXT data to TEXT and BYTE data to BLOB.