Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Customer needs utf8 unicode 520 ci

Discussion in 'Database Discussion' started by WebHostPro, May 30, 2019.

  1. WebHostPro

    WebHostPro Well-Known Member PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,678
    Likes Received:
    23
    Trophy Points:
    318
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Twitter:
    I have a single customer that needs utf8 unicode 520 ci to work for his databases. I found one thread here that listed this tool:
    phoca.cz/documents/38-tools/154-how-to-change-collation-in-database

    It's old though. Is running this script to change the database the best way to have a single account be able to use utf8 unicode 520 ci for it's database?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 WebHostPro, May 30, 2019
    Last edited by a moderator: May 30, 2019
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,529
    Likes Received:
    2,181
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @WebHostPro,

    MySQL provides some useful information about database character set and collation on the link below:

    MySQL :: MySQL 5.6 Reference Manual :: 10.3.3 Database Character Set and Collation

    There's no automated script referenced on the link above, but it's useful for learning general information before proceeding with a third-party script.

    I'm not familiar enough with the tool in the link you provided to make a recommendation on it's use, but WordPress offers a guide on the link below that references an example script:

    Converting Database Character Sets « WordPress Codex

    It's intended for WordPress, but the information and example are applicable should you decide to adjust it for another script's database.

    I'm sure you're planning to backup the database beforehand, but for anyone else reading this thread, remember to backup the database before making any changes.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice