Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.6Mb
PDF (A4) - 41.7Mb
HTML Download (TGZ) - 9.3Mb
HTML Download (Zip) - 9.4Mb
Man Pages (TGZ) - 262.1Kb
Man Pages (Zip) - 372.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Replication and Character Sets

17.5.1.3 Replication and Character Sets

The following applies to replication between MySQL servers that use different character sets:

  • If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so that they do not implicitly rely on the database default character set. A good workaround is to state the character set and collation explicitly in CREATE TABLE statements.