{"id":9913,"date":"2025-09-09T09:30:48","date_gmt":"2025-09-09T06:30:48","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=9913"},"modified":"2025-09-09T09:49:18","modified_gmt":"2025-09-09T06:49:18","slug":"sql-unknown-collation-utf8mb4_unicode_ci-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/sql-unknown-collation-utf8mb4_unicode_ci-hatasi-cozumu\/","title":{"rendered":"SQL Unknown collation utf8mb4_unicode_ci Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p style=\"text-align: left;\">Veritaban\u0131 i\u015flemlerinde SQL dosyalar\u0131n\u0131 import ederken kar\u015f\u0131la\u015f\u0131lan <strong>#1273 &#8211; Unknown collation utf8mb4_unicode_ci<\/strong> hatas\u0131 ile kar\u015f\u0131la\u015fman\u0131z durumunda a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edip hatay\u0131 h\u0131zl\u0131ca \u00e7\u00f6z\u00fcmleyebilirsiniz.<\/p>\n<h2 style=\"text-align: center;\">Hata \u00d6rne\u011fi<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9915\" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/07\/hata-300x49.png\" alt=\"Unknown collation utf8mb4_unicode_ci\" width=\"361\" height=\"59\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/07\/hata-300x49.png 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/07\/hata.png 384w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/p>\n<h2 style=\"text-align: center;\">Hata \u00c7\u00f6z\u00fcm\u00fc<\/h2>\n<p>Hata mesaj\u0131nda hangi collation&#8217;\u0131n tan\u0131nmad\u0131\u011f\u0131 net bir \u015fekilde belirtilmi\u015ftir. \u00c7\u00f6z\u00fcm\u00fc i\u00e7in bir metin edit\u00f6r\u00fc (Notepad++, Sublime Text gibi) kullanarak SQL dosyan\u0131z\u0131 a\u00e7\u0131n ard\u0131ndan dosyadaki<\/p>\n<p><strong>utf8mb4_unicode_ci<\/strong> yazan k\u0131s\u0131mlar\u0131 <strong>utf8_general_ci<\/strong><br \/>\n<strong>utf8mb4<\/strong> yazan k\u0131s\u0131mlar\u0131 <strong>utf8<\/strong><br \/>\n<strong>utf8_unicode_520_ci<\/strong> yazan k\u0131s\u0131mlar\u0131 ise <strong>utf8_unicode_ci<\/strong> olarak de\u011fi\u015ftirdikten sonra kaydedip dosyay\u0131 tekrar y\u00fcklemeyi deneyin sorun \u00e7\u00f6z\u00fcmlenmi\u015f olacakt\u0131r.<\/p>\n<p style=\"text-align: center;\">\u0130htiya\u00e7lar\u0131n\u0131za uygun <a class=\"waffle-rich-text-link\" href=\"https:\/\/www.inetmar.com\/hosting\/\">Hosting<\/a> paketlerimize g\u00f6z at\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veritaban\u0131 i\u015flemlerinde SQL dosyalar\u0131n\u0131 import ederken kar\u015f\u0131la\u015f\u0131lan #1273 &#8211; Unknown collation utf8mb4_unicode_ci hatas\u0131 ile kar\u015f\u0131la\u015fman\u0131z durumunda a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edip hatay\u0131 h\u0131zl\u0131ca \u00e7\u00f6z\u00fcmleyebilirsiniz. Hata \u00d6rne\u011fi Hata \u00c7\u00f6z\u00fcm\u00fc Hata mesaj\u0131nda hangi collation&#8217;\u0131n tan\u0131nmad\u0131\u011f\u0131 net bir \u015fekilde&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":9929,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,10,26],"tags":[],"class_list":["post-9913","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlserver","category-plesk","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/9913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=9913"}],"version-history":[{"count":17,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/9913\/revisions"}],"predecessor-version":[{"id":9932,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/9913\/revisions\/9932"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/9929"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=9913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=9913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=9913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}