{"id":282,"date":"2015-08-27T13:08:40","date_gmt":"2015-08-27T13:08:40","guid":{"rendered":"http:\/\/www.eminozlem.com\/?p=282"},"modified":"2015-08-27T13:08:40","modified_gmt":"2015-08-27T13:08:40","slug":"change-all-mysql-db-tables-and-sub-tables-collation-to-utf8","status":"publish","type":"post","link":"https:\/\/eminozlem.com\/tr\/change-all-mysql-db-tables-and-sub-tables-collation-to-utf8\/","title":{"rendered":"Change all mysql db tables and sub tables collation to utf8"},"content":{"rendered":"<pre class=\"lang:php decode:true \">SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') AS mySQL\r\nFROM INFORMATION_SCHEMA.TABLES\r\nWHERE TABLE_SCHEMA= \"myschema\"\r\nAND TABLE_TYPE=\"BASE TABLE\"<\/pre>\n<p>Change &#8220;myschema&#8221; to your db_name , phpmyadmin will print out the commands you need to run&#8230; If any of them are trimmed with a &#8220;\u2026&#8221; click &#8220;print view&#8221; select all commands and run.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT CONCAT(&#8216;ALTER TABLE `&#8217;, TABLE_NAME,&#8217;` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;&#8217;) AS mySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= &#8220;myschema&#8221; AND TABLE_TYPE=&#8221;BASE TABLE&#8221; Change &#8220;myschema&#8221; to your db_name , phpmyadmin will print out the commands you need to run&#8230; If any of them are trimmed with a &#8220;\u2026&#8221; click &#8220;print view&#8221; select all commands and run.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[7],"tags":[19,67],"class_list":["post-282","post","type-post","status-publish","format-standard","hentry","category-coding","tag-mysql","tag-utf8"],"acf":[],"_links":{"self":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/posts\/282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/comments?post=282"}],"version-history":[{"count":0,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/posts\/282\/revisions"}],"wp:attachment":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/media?parent=282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/categories?post=282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/tags?post=282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}