{"id":884,"date":"2018-03-01T16:28:34","date_gmt":"2018-03-01T16:28:34","guid":{"rendered":"https:\/\/www.ozankabuk.com.tr\/?p=215"},"modified":"2022-09-30T21:12:13","modified_gmt":"2022-09-30T21:12:13","slug":"utf8_general_ci-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.melibera.com\/blog\/utf8_general_ci-hatasi-cozumu.html","title":{"rendered":"utf8_general_ci Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>WordPress web sitelerinizi ta\u015f\u0131rken \u00e7ok nadirde olsa veritaban\u0131 yede\u011fi y\u00fcklemesi esnas\u0131nda utf8_general_ci hatas\u0131 alman\u0131z bir ihtimaldir. \u00d6ncelikle bu hata uyu\u015fmayan veritabanlar\u0131ndan dolay\u0131 kar\u015f\u0131n\u0131za \u00e7\u0131kmaktad\u0131r. Bu hatan\u0131n giderilmesi ile ilgili iki adet \u00e7\u00f6z\u00fcm yolu vard\u0131r. Birincisi mysql s\u00fcr\u00fcm\u00fcn\u00fcn g\u00fcncellenmesi ikincisi ise veritaban\u0131 \u00fczerinde bir ka\u00e7 i\u015flem yapman\u0131z olacakt\u0131r.<br \/>\n<strong><br \/>\nBirinci y\u00f6ntem;<\/strong><br \/>\nE\u011fer bir <a href=\"https:\/\/www.melibera.com\/kategori\/hosting\/\">hosting<\/a> kullan\u0131c\u0131s\u0131 iseniz bu y\u00f6ntem size g\u00f6re olmayabilir. Bunun nedeni hosting firmalar\u0131 sunucu \u00fczerinden bar\u0131nan di\u011fer web sitelerini d\u00fc\u015f\u00fcnerek bu i\u015flemi yapmaktan ka\u00e7\u0131nabilirler. Ancak kendi sunucununuz varsa sunucunuzun mysql s\u00fcr\u00fcm\u00fcn\u00fc g\u00fcncellemeniz problmi giderecektir.<\/p>\n<p><strong>\u0130kinci y\u00f6ntem;<\/strong><br \/>\n\u00d6ncelike notepad++ program\u0131n\u0131 indirerek bilgisayar\u0131n\u0131za kurmak bu i\u015flemde size b\u00fcy\u00fck bir kolayl\u0131k sa\u011flayacakt\u0131r. \u0130\u015flemimize ba\u015flamak i\u00e7in sql olarak ald\u0131\u011f\u0131m\u0131z veritaban\u0131 yede\u011fini notepad++ ile a\u00e7\u0131yoruz ve klavyemizden CTRL F butonlar\u0131na bas\u0131yoruz. Kar\u015f\u0131m\u0131za gelen ekranda sekmelerden de\u011fi\u015ftir sekmesine geliyoruz ve s\u0131ras\u0131 ile a\u015fa\u011f\u0131daki \u015fekilde i\u015fleme ba\u015fl\u0131yoruz.<\/p>\n<ol>\n<li>Aranan k\u0131sm\u0131na &#8220;utf8mb4_unicode_ci&#8221; yaz\u0131yoruz De\u011fi\u015ftir k\u0131sm\u0131na &#8220;utf8_general_ci&#8221; yaz\u0131yoruz ve t\u00fcm\u00fcn\u00fc de\u011fi\u015ftir butonuna bas\u0131yoruz.<\/li>\n<li>Aranan k\u0131sm\u0131na &#8220;utf8mb4_unicode_520_ci&#8221; yaz\u0131yoruz De\u011fi\u015ftir k\u0131sm\u0131na &#8220;utf8_general_ci&#8221; yaz\u0131yoruz ve t\u00fcm\u00fcn\u00fc de\u011fi\u015ftir butonuna bas\u0131yoruz.<\/li>\n<li>Aranan k\u0131sm\u0131na &#8220;utf8mb4&#8221; yaz\u0131yoruz De\u011fi\u015ftir k\u0131sm\u0131na &#8220;utf8&#8221; yaz\u0131yoruz ve t\u00fcm\u00fcn\u00fc de\u011fi\u015ftir butonuna bas\u0131yoruz.<\/li>\n<\/ol>\n<p>Yukar\u0131daki i\u015flemleri yapt\u0131ktan sonra veritaban\u0131n\u0131 kaydediyor ve phpmyadmin \u00fczerinden veritaban\u0131 dosyam\u0131z\u0131 y\u00fckl\u00fcyoruz. Bu i\u015flem sonras\u0131nda y\u00fckleme i\u015fleminde herhangi bir hata vermeyecektir ve ba\u015far\u0131l\u0131 bir \u015fekilde y\u00fcklenecektir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WordPress web sitelerinizi ta\u015f\u0131rken \u00e7ok nadirde olsa veritaban\u0131 yede\u011fi y\u00fcklemesi esnas\u0131nda utf8_general_ci hatas\u0131 alman\u0131z bir ihtimaldir. \u00d6ncelikle bu hata uyu\u015fmayan &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"utf8_general_ci Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc\" class=\"read-more button\" href=\"https:\/\/www.melibera.com\/blog\/utf8_general_ci-hatasi-cozumu.html#more-884\" aria-label=\"More on utf8_general_ci Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc\">Devam\u0131\u0131n\u0131 Oku<\/a><\/p>\n","protected":false},"author":1,"featured_media":849,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[72,183,208,229,231],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts\/884"}],"collection":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/comments?post=884"}],"version-history":[{"count":1,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":1711,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions\/1711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/media\/849"}],"wp:attachment":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}