change mysql default charset

mahdy_sharifi

• January 31, 2017 14:16

our Mysql server hosted over 50 database and 100 G disk, Is it safe changing Mysql Server default charset to utf8mb4 ? maybe user website break due this change ? Thanks

• 

  cPanelMichael

  • January 31, 2017 21:50

  Hello, There's an older thread where this is discussed at: default MySQL collation and character set / charset You can also search for the following term on our forums to see discussions of similar topics on other threads:
  mysql "character set"
  Thank you.

  0
• 

  mahdy_sharifi

  • February 08, 2017 07:16

  my question not related How can do this . I want know is this changing safe for existing database like User database, Cpanel database (horde, mysql, roundcube ... ) ?

  0
• 

  cPanelMichael

  • February 08, 2017 18:29

  Hello, Changing the default MySQL character set for the server only affects new databases created after the change. Existing databases are not affected unless you alter their character sets. You can review MySQL documentation on this topic for more information on how this works: MySQL :: MySQL 5.6 Reference Manual :: 10.5 Character Set Configuration MySQL :: MySQL 5.6 Reference Manual :: 10.1.3.3 Database Character Set and Collation MariaDB also provides a useful document if you plan to switch to MariaDB in the future: Setting Character Sets and Collations Thank you.

  0

Please sign in to leave a comment.