To ensure that foreign language strings are replicated properly to your target database via a SQL DataSync 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&characterEncoding=UTF-8</database_parms>
<database>psp_repl</database>
</task>
</subscribe>