Data Types
DataSync settings are accessed by clicking Gear Icon -> Settings.
The Data Types page controls how DataSync interprets certain data types. Here is a description of the available items:
Convert LOBs to VARCHAR or VARBINARY
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.
Preserve LOBs
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.
Treat CHAR as CLOB on Target Table
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.
Treat CHAR as VARCHAR on Target Table
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.
Maximum Number/Decimal Precision
This option allows you to set the maximum numeric or decimal precision value.