Is the string declared with a fixed length ?
Source position: db.pas line 540
public property TStringField.FixedChar : Boolean |
FixedChar is True if the underlying data engine has declared the field with a fixed length, as in a SQL CHAR() declaration: the field's value will then always be padded with as many spaces as needed to obtain the declared length of the field. If it is False then the declared length is simply the maximum length for the field, and no padding with spaces is performed.