Page 1 of 1

Problem when Saving CLOB field (Data is Truncated)

Posted: 04.04.2016, 14:10
by 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.

Re: Problem when Saving CLOB field (Data is Truncated)

Posted: 06.04.2016, 18:56
by 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

Re: Problem when Saving CLOB field (Data is Truncated)

Posted: 06.04.2016, 19:20
by miab3
@eduardoalcantara80,

Try with ControlsCodePage cCP_UTF16.

Michal