{"id":2558,"date":"2014-12-12T06:25:49","date_gmt":"2014-12-12T06:25:49","guid":{"rendered":"http:\/\/www.esds.co.in\/kb\/?p=2558"},"modified":"2014-12-12T06:25:49","modified_gmt":"2014-12-12T06:25:49","slug":"how-can-i-change-my-mysql-database-collation","status":"publish","type":"post","link":"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/","title":{"rendered":"How can I change my MySQL database collation?"},"content":{"rendered":"

Generally you would require to change your MySQL collation<\/strong> so as to solve any problems with foreign character encodings. The very common step that can be taken here is to change your MySQL collation from latin1 to utf8. The same can be changed by using phpMyAdmin and the by following the below mentioned steps :<\/p>\n

1. First you need to login to your cPanel account provided with your web hosting account and then click on phpMyAdmin icon located in the Database Box.<\/p>\n

2. Now you need to select the Database you would want to manage from the drop down menu located on the left.<\/p>\n

3. Then click on the Operations tab in the top menu of your phpMyAdmin<\/p>\n

4. Once you click on Operations you will see at the bottom of the page the collation option. You need to now select a collation from the drop down menu and click on the Go button.<\/p>\n

Please be informed that after you change the collation of a database only the new tables will be created with the new collation. \u00a0All the other tables will remain with the collation, they were initially created with.<\/p>\n","protected":false},"excerpt":{"rendered":"

Generally you would require to change your MySQL collation so as to solve any problems with foreign character encodings. The very common step that can be taken here is to change your MySQL collation from latin1 to utf8. The same can be changed by using phpMyAdmin and the by following the below mentioned steps :… <\/p>\n

<\/div>\n

Read More<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[624],"tags":[],"aioseo_notices":[],"yoast_head":"\nHow can I change my MySQL database collation?<\/title>\n<meta name=\"description\" content=\"KB including simple step by step procedure to be followed to change MySQL database collation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I change my MySQL database collation?\" \/>\n<meta property=\"og:description\" content=\"KB including simple step by step procedure to be followed to change MySQL database collation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/\" \/>\n<meta property=\"og:site_name\" content=\"ESDS Official Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ESDSdc\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-12T06:25:49+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ESDSDataCenter\" \/>\n<meta name=\"twitter:site\" content=\"@ESDSDataCenter\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#website\",\"url\":\"https:\/\/www.esds.co.in\/kb\/\",\"name\":\"ESDS Official Knowledgebase\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.esds.co.in\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/#webpage\",\"url\":\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/\",\"name\":\"How can I change my MySQL database collation?\",\"isPartOf\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/#website\"},\"datePublished\":\"2014-12-12T06:25:49+00:00\",\"dateModified\":\"2014-12-12T06:25:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/#\/schema\/person\/d951a1b6843822458f3c5f5ee02a74e8\"},\"description\":\"KB including simple step by step procedure to be followed to change MySQL database collation.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/\",\"url\":\"https:\/\/www.esds.co.in\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/\",\"url\":\"https:\/\/www.esds.co.in\/kb\/how-can-i-change-my-mysql-database-collation\/\",\"name\":\"How can I change my MySQL database collation?\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#\/schema\/person\/d951a1b6843822458f3c5f5ee02a74e8\",\"name\":\"ESDS ADMIN\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5618393df3c15e5b6b3b9ef917e83827?s=96&d=mm&r=g\",\"caption\":\"ESDS ADMIN\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/2558"}],"collection":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/comments?post=2558"}],"version-history":[{"count":2,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/2558\/revisions"}],"predecessor-version":[{"id":3333,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/2558\/revisions\/3333"}],"wp:attachment":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/media?parent=2558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/categories?post=2558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/tags?post=2558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}