Subject Re: Issues with String Truncation error on insert (FB 2.1 64 bits windows server)
Author Dmitry Yemanov
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.