iAnywhere.com - Replication Server character set and language issues

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Replicating Data with Replication Server » Configuring databases for Replication Server

Replication Server character set and language issues

Upon creation, each SQL Anywhere database is assigned a specific collation (character set and sort order). Replication Server uses a different set of identifiers for character sets and sort orders.

Set the character set and language parameters in the LTM configuration file. If you are unsure of the character set label to specify, you can do the following to determine the character set of the server:

To determine the character set

Execute the following command:
```
exec sp_serverinfo csname
```

For a list of language labels, see Language label values.

Identifiers in Replication Server

If you are using the SQL Anywhere Replication Agent with Replication Server 15.0 and Open Client/Open Server 15.0, the Replication Agent supports table, column, procedure, function, and parameter names up to 128 bytes in length.

The maximum length for identifiers when using the Replication Agent with older versions of Replication Server and Open Client/Open Server is 30 bytes.