Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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

Columns defined as NCLOB will, in all essentials, be treated as being the same as NCHAR VARYING with a maximum length of 5 000 characters.

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
Mimer Information Technology AB
Phone: +46 18 780 92 00
info@mimer.com
Mimer SQL Documentation TOC PREV NEXT INDEX