Large OBjects (LOBs) data types

Use TEXT and BYTE FGL types to store database character and binary large objects.

Genero BDL provides the TEXT data type to store character LOBs and the BYTE data type to store binary LOBs.

The TEXT and BYTE types can be used to handle large objects data from various database brands. However, some database types are not supported.

Table 1. Large OBjects support with TEXT/BYTE
Database Server Type LOBs support with TEXT/BYTE
IBM® DB2® LUW Yes, see details
IBM Informix® Yes, native SQL feature
IBM Netezza N/A, see details
Microsoft™ SQL Server Yes, see details
Oracle® MySQL / MariadDB Yes, see details
Oracle Database Server Yes, see details
PostgreSQL Yes, see details
SAP® ASE Yes (with limitations), see details
SAP HANA® Yes, see details
SQLite Yes, see details