Problem when Saving CLOB field (Data is Truncated)
Posted: 04.04.2016, 14:10
Hi All,
I have a simple table with a varchar(20), a number and a CLOB field.
Whenever I save data with more than 2910 characters the text save is truncated to this value.
I am using XE3 and I tested the same database with XE8 and FireDAC and the firedat saved the CLOB field correctly.
I noticed that in FireDAC it detects the field as BlobType = ftOraClob, but ZEOSLIB detects it as ftMemo.
I have a simple table with a varchar(20), a number and a CLOB field.
Whenever I save data with more than 2910 characters the text save is truncated to this value.
I am using XE3 and I tested the same database with XE8 and FireDAC and the firedat saved the CLOB field correctly.
I noticed that in FireDAC it detects the field as BlobType = ftOraClob, but ZEOSLIB detects it as ftMemo.