SQL adaptation guide for SQLite 3.x / Data dictionary |
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.
The SQLite database interface can convert BDL TEXT data to TEXT and BYTE data to BLOB.