CREATE TABLE WITH LOB COLOUMNS
I am trying to create tables with LOB (BLOB/CLOB) columns. I tried with this simple stmt in database studio,SQL editor:
CREATE TABLE TEMP(TESTC1 INTEGER, TESTC2 BLOB)
But i am getting this error:
Error Executing 'CREATE TABLE TEMP(TESTC1 INTEGER, TESTC2 BLOB NOT null)' [-4006] (at 42): Unknown domain name:BLOB.
Also when i am using the Database Studio wizard to create table i am not getting any LOB column option in the column definition.
LONG is known in 7.6, 7.7 and even 7.8 to have a longer time for changing it.
CLOB/BLOB is not known in 7.6.
I think, this will help with the decision.