Problem when Saving CLOB field (Data is Truncated)

[eduardoalcantara80]

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.

[marsupilami]

Hello Eduardo,

which database server and server version do you use (i.e. Firebird 2.5, PostgreSQL 9.5, ...) and which version of Zeos? Can you supply an example table DDL?
With best regards,

Jan Baumgarten

[miab3]

@eduardoalcantara80,

Try with ControlsCodePage cCP_UTF16.

Michal