Language, Sort Order, and Character Set Issues

Errors may occur when you use localization features.

Replication Server provides support for international environments with:

Localization of messages into English, French, German, Spanish, Chinese, Korean, and Japanese languages
Support for all Sybase-supported character sets, with character set conversion between Replication Server sites
Support for nonbinary sort orders

Because Replication Server works in a distributed environment with many independent processes, you must set up its languages, sort orders, and character sets carefully to avoid problems. Problems can arise when you do not set up these items according to the guidelines recommended in the Replication Server Design Guide.

Note: RepAgent uses the same language, sort order, and character set settings that the Adaptive Server uses.

Message Language Problems
You can configure Replication Servers to print messages to the error log and to clients in English, and other foreign languages. This allows server programs in your replication system, including Replication Servers, and Adaptive Servers, to write messages to their error logs in the configured language. Depending on the server, they may or may not send messages to a client in the client’s language.
Sort Order Problems
Most sort order problems in Replication Server are a result of different sort orders being used in different servers throughout your system.
Character Set Problems
Character set problems can arise when servers have different or incompatible character sets.