User Tools

Site Tools


replicator_agent_troubleshooting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
replicator_agent_troubleshooting [2018/11/30 00:11]
timothy.pike [Foreign Character Replication with MySQL 8]
replicator_agent_troubleshooting [2018/11/30 00:13] (current)
timothy.pike [Foreign Character Replication with MySQL 8]
Line 123: Line 123:
 <wrap round info>​[[europium_release|Europium]]</​wrap>​ <wrap round info>​[[europium_release|Europium]]</​wrap>​
  
-As of the [[europium_release|Europium release]], the Perspectium Replicator Agent supports MySQL 8. With this upgrade, heightened validation occurs with respect to how the Agent handles [[https://​www.fileformat.info/​info/​charset/​UTF-8/​list.htm|foreign characters (specifically,​ UTF-8 characters with 3+ bytes)]], and character encoding can differ between the Agent and local databases. As a result, you may be unable to replicate foreign characters to certain columns such as the **incident** column. The reason for this change is that the MySQL Connector/​J ​driver for version 8+ now handles UTF-8 character encoding differently. By default, this driver only supports 3-byte UTF-8 characters instead of the standard 4-byte. ​+As of the [[europium_release|Europium release]], the Perspectium Replicator Agent supports MySQL 8. With this upgrade, heightened validation occurs with respect to how the Agent handles [[https://​www.fileformat.info/​info/​charset/​UTF-8/​list.htm|foreign characters (specifically,​ UTF-8 characters with 3+ bytes)]], and character encoding can differ between the Agent and local databases. As a result, you may be unable to replicate foreign characters to certain columns such as the **incident** column. The reason for this change is that the MySQL Connector/J driver only supports ​encoding for 3-byte UTF-8 characters instead of the standard 4-byte. ​
  
 If you are replicating foreign characters (UTF-8 characters with 3+ bytes) to a local database using the Perspectium Replicator Agent, you will need to set the value for the **default-character-set** property in your MySQL configuration file to **utf8mb4**. If you are replicating foreign characters (UTF-8 characters with 3+ bytes) to a local database using the Perspectium Replicator Agent, you will need to set the value for the **default-character-set** property in your MySQL configuration file to **utf8mb4**.
replicator_agent_troubleshooting.txt ยท Last modified: 2018/11/30 00:13 by timothy.pike