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), National Character Large OBject (NCLOB) 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 NCLOB will, in all essentials, be treated as being the same as NCHAR VARYING with a maximum length of 5 000.
Columns defined as BLOB will be treated as BINARY VARYING with a maximum length of 15 000.
LOBs larger than these limits cannot be entered as input, and will be truncated as output.
For more information on LOB data types, see the Mimer SQL Reference Manual, Data Types in SQL Statements.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40