change mysql default charset
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
-
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 -
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 -
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.
Comments
3 comments