{"id":84,"date":"2008-01-21T18:35:11","date_gmt":"2008-01-21T16:35:11","guid":{"rendered":"http:\/\/www.shukko.com\/x3\/2008\/01\/21\/php5-mysql-5-turkce-karakter-problemi\/"},"modified":"2008-04-28T01:44:11","modified_gmt":"2008-04-27T23:44:11","slug":"php5-mysql-5-turkce-karakter-problemi","status":"publish","type":"post","link":"https:\/\/www.shukko.com\/x3\/2008\/01\/21\/php5-mysql-5-turkce-karakter-problemi\/","title":{"rendered":"PHP5 + Mysql 5 T\u00fcrk\u00e7e Karakter Problemi"},"content":{"rendered":"<p><code><br \/>\nPHP5 + Mysql 5 T\u00fcrk\u00e7e Karakter Problemi<br \/>\n2005-12-22 11:15:43<br \/>\nPHP5 + MYSQL 5 ikilisinin kurulu oldu\u011fu bir sunucuda \u015fu \u015fekilde bir sorun ile kar\u015f\u0131la\u015fm\u0131\u015ft\u0131m. Bu problemi linux listelerindeki arkada\u015flara da sordum ve saolsunlar yard\u0131mc\u0131 oldular. Bende \u015fimdi sizlerle payla\u015fmak istedim.<\/code><code>Site \u00fczerinden mysql 'den veri \u00e7eken php dosyas\u0131n\u0131 \u00e7a\u011f\u0131rd\u0131\u011f\u0131mda T\u00fcrk\u00e7e karakterler ? \u015feklinde g\u00f6z\u00fck\u00fcyordu. Bunun bir \u00e7ok nedeni olabilirdi ba\u015flang\u0131\u00e7ta. Mysql 'i latin5 charset ile ba\u015flatmak sorunu \u00e7\u00f6zebilirdi ama yetmedi. Daha sonra bu problemin mysql in bir bug '\u0131 oldu\u011funu ve mysql i \u00e7al\u0131\u015ft\u0131r\u0131rken verilen bir parametre ile bunun d\u00fczeltilebildi\u011fini \u00f6\u011frendim. Do\u011fruymu\u015f:)<\/p>\n<p>\/etc\/my.cnf dosyam\u0131 \u015fu \u015fekilde d\u00fczenledim:<\/p>\n<p>[root@~~]# cat \/etc\/my.cnf<br \/>\n[mysqld]<br \/>\ndatadir=\/var\/lib\/mysql<br \/>\n#socket=\/var\/lib\/mysql\/mysql.sock<br \/>\ndefault-character-set=latin5<br \/>\n#character-sets-dir=\/usr\/share\/mysql\/charsets<br \/>\n#default-collation=latin5_turkish_ci<br \/>\nmax_connections = 400<\/p>\n<p>[mysql.server]<br \/>\nuser=mysql<br \/>\ndefault-character-set=latin5<\/p>\n<p>[safe_mysqld]<br \/>\nerr-log=\/var\/log\/mysqld.log<\/p>\n<p>[mysql]<br \/>\ndefault-character-set=latin5<\/p>\n<p>ve bu conf. dosyas\u0131na ek olarak mysql s\u00fcrecini ba\u015flatan beti\u011fe a\u015fa\u011f\u0131daki parametre yi de ekliyorsunuz.<\/p>\n<p>--skip-character-set-client-handshake<\/p>\n<p>Bu parametre, varsay\u0131lan server karakter setini kullanan ve clientlar taraf\u0131ndan g\u00f6nderilen karakter set bilgisini yok sayar.<\/p>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PHP5 + Mysql 5 T\u00fcrk\u00e7e Karakter Problemi 2005-12-22 11:15:43 PHP5 + MYSQL 5 ikilisinin kurulu oldu\u011fu bir sunucuda \u015fu \u015fekilde bir sorun ile kar\u015f\u0131la\u015fm\u0131\u015ft\u0131m. Bu problemi linux listelerindeki arkada\u015flara da sordum ve saolsunlar yard\u0131mc\u0131 oldular. Bende \u015fimdi sizlerle payla\u015fmak istedim.Site \u00fczerinden mysql &#8216;den veri \u00e7eken php dosyas\u0131n\u0131 \u00e7a\u011f\u0131rd\u0131\u011f\u0131mda T\u00fcrk\u00e7e karakterler ? \u015feklinde g\u00f6z\u00fck\u00fcyordu. Bunun bir [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":0,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}