CLOB/BLOB Support for APL Database Functions

Owned by Jenni Wallin
Apr 25, 2023
1 min read
Case IDInternal IDComponentPackage

MZ-37832

APL
Analysis Agent

databasefunctions_8.3.0.0.mzp
database_bulk_lookup_8.3.0.0.mzp
docweb_8.3.0.0.mzp

The database functions in the APL will now support the parsing of CLOB and BLOB data types. BLOB is parsed and stored as hex string and CLOB data as string. String or Bytearray data types are used when inserting BLOB data using APL.

Warning!

PostgreSQL does not support BLOB/CLOB. The BLOB equivalent for PostgreSQL will be BYTEA and CLOB equivalent will be TEXT.


For further reading see 9. Database Functions.