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:

• unencrypted - data is sent unencrypted and unencoded
• encrypted - data is encrypted and base64 encoded
• encrypted_multibyte - base64 encode the data before encrypting for utmost compatibility

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.

        <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&amp;characterEncoding=UTF-8</database_parms>
                <database>psp_repl</database>
            </task>
        </subscribe>

For additional help see the Agent Troubleshooting page for multibyte encrytion/decryption.