Subject Issues with String Truncation error on insert (FB 2.1 64 bits windows server)
Author fabianchocron
Hi All,

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);

We did not modify the application because we don't have at this stage the ability to recompile it without a massive effort.

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? Or are we doing something wrong?