Failed to select 50MB CLOB data in CUBRID Manager, but suceeded to select 25MB data
Hello, the table contains CLOB type column, and I inserted 51MB text.
I could select 25MB text by CLOB_TO_CHAR in CUBRID Manager, I failed to select 50MB or bigger text.
When I didn' tuse CLOB_TO_CHAR function and run SELECT, it works to read column's data (file path) however when using ClOB_TO_CHAR to read its content, it failed.
In addition, when I insert 80MB text content into the column, it works in few seconds. However for 100MB text content, it failed to insert although it took more than 10 minutes.
2) Create Table DDL for your convenience:
CREATE TABLE tbl_Content ( aaa CHARACTER VARYING(100)NOT NULL, contenttype INTEGER, content CLOB, );
3) Query for your conveinece:
SELECT CLOB_TO_CHAR(content) FROM tbl_agent_filecontent WHERE aaa = 'conditions'