LOBs in BSQL
Although BSQL is not designed to handle Large OBjects (LOBs), it does provide limited LOB support for testing purposes.
A LOB is a column defined as being of type Character Large OBject (CLOB) or Binary Large OBject (BLOB).
Columns defined as CLOB will, in all essentials, be treated as being the same as VARCHAR with a maximum length of 15 000.
Columns defined as BLOB will be treated as BINARY VARYING with a maximum length of 15 000.
For more information on LOB data types, see the Mimer SQL Reference Manual, Chapter 5, Data Types in SQL Statements.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40