Is it possible to add BLOB Wide Memo field to a nexusdb table using a query?

Question

I am developing a database comparing tool using delphi and nexusdb. I tried to add a BLOB Wide Memo field to a table using query. but i could not find the correct data type. i tried follow queries.

ALTER TABLE Test ADD COLUMN TestField BLOBWideMemo;
ALTER TABLE Test ADD COLUMN TestField NATIONAL CHARACTER LARGE OBJECT;
ALTER TABLE Test ADD COLUMN TestField BLOB Wide Memo;

Answer 1

Try this

ALTER TABLE Test ADD COLUMN TestField NCLOB