"Gene Neely" <paul.neely@comcast.net> writes:
> I have found no way to automatically trim fields to the length of the
> varchar or char on inserts and updates.
Write an explicit cast to varchar(N) or whatever it is.
> Can this become a Configuration option???
No, because the behavior is required by the SQL standard.
regards, tom lane