Encoding system parameters

For some system parameters, you can set the default method for treating data in defined Unicode columns, and you can set the default character encoding for your database.

Encoding considerations for native apply utilities

When using the FastLoad utility for refresh, you need to ensure that target tables do not have mixed encodings. The encodings must be identical between the source and target tables.

You must also ensure that the following system parameters are set according to the target table default encoding:

If the target table encoding is Latin, ensure that the mbcs_support_is_on system parameter is set to false.
If the target table encoding is Unicode, ensure that the mbcs_support_is_on system parameter is set to true.

The following list indicates the system parameters available for this category: