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.
| 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 |