Character set settings in the LTM configuration file

Three settings in the LTM configuration file refer to character set issues:

  • LTM_charset   The character set for the LTM to use. You can specify any Sybase-supported character set.

  • LTM_language   The language used by the LTM to print its messages to the error log and to its clients. You can choose any language to which the LTM has been localized, as long as it is compatible with the LTM character set.

    The SQL Anywhere LTM has been localized to several languages.

  • LTM_sortorder   The Open Client/Open Server sort order for the LTM to use to compare user names. You can specify any Adaptive Server Enterprise-supported sort order that is compatible with the LTM's character set. All sort orders in your replication system should be the same. The default sort order is a binary sort.

Notes

Character set   In an Open Client/Open Server environment, an LTM should use the same character set as the data server and Replication Server attached to it.

SQL Anywhere character sets are specified differently than Open Client/Open Server character sets, so the requirement is that the SQL Anywhere character set must be compatible with the LTM character set.

Language   The locales.dat file in the locales subdirectory of the Sybase release directory contains valid map settings. However, the LTM output messages in the user interface are currently available in those languages to which the LTM has been localized.

Sort order   All sort orders in your replication system should be the same. You can find the default entry for your platform in the locales.dat file in the locales subdirectory of the Sybase release directory.

Example
  • The following settings are valid for a Japanese installation:

    LTM_charset=SJIS
    LTM_language=Japanese