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