{"id":30099,"date":"2021-01-18T03:12:31","date_gmt":"2021-01-17T19:12:31","guid":{"rendered":"https:\/\/web.mwwsb.com.my\/pjci\/?post_type=kb&p=30099"},"modified":"2022-09-08T19:13:32","modified_gmt":"2022-09-08T11:13:32","slug":"how-to-change-the-mysql-collation-settings-in-phpmyadmin","status":"publish","type":"kb","link":"https:\/\/www.casbay.com\/guide\/kb\/how-to-change-the-mysql-collation-settings-in-phpmyadmin","title":{"rendered":"HOW TO: Change the MySQL collation settings in phpMyAdmin"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Change the MySQL collation settings in phpMyAdmin<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

ABOUT CHARACTER SETS AND COLLATION<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

MySQL enables you to store and process data in a wide variety of languages using various character sets. For some operations, such as comparing two strings, MySQL uses a set of rules to determine equality and sorting order. This set of rules is known as a\u00a0collation<\/em>.<\/p>

You may have to change the collation for a database or table based on the character set you want to use for string data. You can do this by using the phpMyAdmin tool in cPanel.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

CHANGING THE DEFAULT COLLATION FOR A DATABASE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

To change the default collation for a database, follow these steps:<\/p>

  1. In the\u00a0Databases<\/strong>\u00a0section of the cPanel home screen, click\u00a0phpMyAdmin<\/strong>. The phpMyAdmin administration page appears in a new window.

    <\/li>
  2. In the left pane, click the name of the database you want to modify.

    <\/li>
  3. Then, click Operations <\/strong>on the top menu bar.

    <\/li>
  4. Under\u00a0Collation<\/strong>, select the collation that you want for the database, and then click\u00a0Go<\/strong>.
    This setting only affects new tables that you create. Any existing tables maintain their current collation setting.<\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    CHANGING THE COLLATION FOR A TABLE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t

    To change the collation for a database table, follow these steps:<\/p>

    1. In the\u00a0Databases\u00a0<\/strong>section of the cPanel home screen, click\u00a0phpMyAdmin<\/strong>. The phpMyAdmin administration page appears in a new window.

      <\/li>
    2. In the left pane, click the\u00a0+<\/strong>\u00a0icon next to the name of the database that contains the table you want to modify. phpMyAdmin expands the view to show the database\u2019s tables.

      <\/li>
    3. After that, click the name of the table you want to modify.

      <\/li>
    4. On the top menu bar, click\u00a0Operations<\/strong>.

      <\/li>
    5. Lastly, select the collation that you want in the\u00a0Collation\u00a0<\/strong>list box under\u00a0Table<\/strong>\u00a0options <\/strong>for the table, and then click Go<\/strong>.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t

      For more information about character sets and collation in MySQL,\u00a0please visit<\/a>. Check out the next guide on HOW TO: Manage MySQL<\/a>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

      Change the MySQL collation settings in phpMyAdmin This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables. ABOUT CHARACTER SETS AND COLLATION MySQL enables you to store and process data in a wide variety of languages using various character sets. For some operations, such as comparing two strings, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[60],"kbtag":[106],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/30099"}],"collection":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/comments?post=30099"}],"version-history":[{"count":2,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/30099\/revisions"}],"predecessor-version":[{"id":36541,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/30099\/revisions\/36541"}],"wp:attachment":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/media?parent=30099"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=30099"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtag?post=30099"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=30099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}