Use the Treat CHAR as VARCHAR on Target Table at options to save space in your database table.
On the Settings tab, click the Data Types sub-tab.
If character fields are Long and not fully populated, click Treat CHAR as VARCHAR on Target Table at and enter the field size.
Note: The field should contain at least 5 characters as there is minimal space savings for short CHAR fields.
Example: If the source table has a CHAR(100) field that averages 10 characters in length, it will be transformed into a VARCHAR(100)
field on the target table after the synchronization. This could save an average of 90 characters per row.