To treat CHAR data types as VARCHAR

Use the Treat CHAR as VARCHAR on Target Table at options to save space in your database table.

  1. On the Settings tab, click the Data Types sub-tab.

    DataTypes-CHAR_VARCHAR.bmp

     

  2.  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.