16.01.2013 8:43, fabianchocron wrote:

>
> We are trying to resolve an issue caused by the Application inserting a
> string larger than the database field size. The planned solution was to
> add a trigger before insert as follows:
> new.string = substring(new.string from 1 for 100);

This is not going to work.

> For some reason that we do not understand the trigger is not working as
> desired, and the insert fails with an arithmetic overflow or string
> truncation error. Is is possible that Firebird 2.1 64 bits has a bug and
> we may need to upgrade to resolve this issue?

OLD/NEW pseudo-records have the same format as regular table records,
inheriting the same length limits. And this is not a bug.


Dmitry