2

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;
Ishanka
  • 360
  • 4
  • 18

1 Answers1

2

Try this

ALTER TABLE Test ADD COLUMN TestField NCLOB
Alexander Farber
  • 21,519
  • 75
  • 241
  • 416
Danush
  • 36
  • 4