This setting tells DataSync to change LOBs to either VARCHAR or VARBINARY depending on the data. Enter the target column size (default is 1024). This is the default setting. When set, Preserve LOBs will not be set.

This setting tells DataSync to send LOBs to the target without converting them to VARCHAR or VARBINARY. When set, incremental updates will not be allowed and only full loads will be supported. When set, Convert LOBs to VARCHAR or VARBINARY will not be set.

Select this option and enter the field size if your target data base does not support very large character fields. The default value is 1024 and there is no minimum or maximum value.

Select this option and enter the field size if character fields are long and not fully populated. The field should contain at least 5 characters as there is minimal space savings for short CHAR fields. For 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.

This option allows you to set the maximum numeric or decimal precision value.