v3.2.3
A new property is now available to describe how data is encrypted when being shared our of your ServiceNow instance, as shown in the following screenshot.
The available modes are:
To ensure that foreign language strings are replicated properly between ServiceNow instances require at least version 3.2.3 of the Update Set to be installed and that encrypted_multibyte encryption mode is selected on the source instance.
To ensure that foreign language strings are replicated properly to your target database via a SQL Replicator Agent, you must configure your database connection string for UTF-8 character encoding. For example, agent.xml config is modified with <database_parms> for MySQL subscriber to add the parameter characterEncoding=UTF-8.
If you have selected unencrypted or encrypted_multibyte encryption modes on the source ServiceNow instance, you must first install and configure a SQL Replicator Agent version 3.2.3 or later.
<subscribe> <task> <task_name>multibyte_tester</task_name> <handler>com.perspectium.replicator.sql.SQLSubscriber</handler> <amqp_queue>psp.out.replicator.dloo_mac</amqp_queue> <decryption_key>The cow jumped over the moon</decryption_key> <database_server>127.0.0.1</database_server> <database_user>xxx</database_user> <database_password>xxx</database_password> <database_port>3306</database_port> <database_type>mysql</database_type> <database_parms>autoReconnect=true&characterEncoding=UTF-8</database_parms> <database>psp_repl</database> </task> </subscribe>
For additional help see the Agent Troubleshooting page for multibyte encrytion/decryption.