The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

change mysql default charset

Discussion in 'Database Discussions' started by mahdy_sharifi, Jan 31, 2017.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    184
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,086
    Likes Received:
    1,288
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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:

    Code:
    mysql "character set"
    Thank you.
     
  3. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    184
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    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 ... ) ?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,086
    Likes Received:
    1,288
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page