Normally, trailing spaces in fields are insignificant when doing joins. For example, if the foreign key field in a child table contains "ABC " (with several spaces at the end) and the primary key field in the parent table contains "ABC" (with no trailing spaces), the join usually works correctly. However, some database engines treat the trailing spaces as significant and the join won't work. In that case, turn the Trailing Spaces Insignificant in Joins setting to false.

See Also

Configuration Settings