Subject Re: [firebird-support] Blank space after varchar trigger thinks equal to old value
Author Ann W. Harrison
Mark Steinberg wrote:
> In Firebrid 1.5 we are running iblog manager which has
> triggers set on each table to record changes to the
> database. It works great until we have a varchar
> field. When we add or take out a blank character the
> trigger will not work. The trigger thinks that the
> values have not changed.

Trailing blanks are not significant in equality comparisons
for character fields per the SQL standard. The LIKE comparison
however considers spaces significant. You might be able to use