To treat CHAR data types as CLOB

Use the Treat CHAR as CLOB on Target Table at options if your target data base does not support very large character fields (like SQL Server).

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

    DataTypes-CHAR_CLOB.bmp

     

  2.  If your target data base does not support very large character fields, click Treat CHAR as CLOB on Target Table at and enter the field size.

The default value is 1024 but there is no minimum or maximum value.