{"id":30150,"date":"2019-03-26T18:02:33","date_gmt":"2019-03-26T09:02:33","guid":{"rendered":"https:\/\/jirak.net\/wp\/?p=30150"},"modified":"2019-03-26T18:02:36","modified_gmt":"2019-03-26T09:02:36","slug":"charsetutf8-vs-set-names-utf8-in-php-pdo_mysql","status":"publish","type":"post","link":"https:\/\/jirak.net\/wp\/charsetutf8-vs-set-names-utf8-in-php-pdo_mysql\/","title":{"rendered":"charset=utf8 VS &#8216;SET NAMES &#8220;utf8&#8243;&#8216; in PHP pdo_mysql"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>pdo_mysql \uae30\ubc18\uc758 DB\ucee4\ub125\uc158\uc744 \ucc3e\ub2e4\ubcf4\ub2c8<br>\uc18c\uac1c\ud558\ub294 \uae00\ub9c8\ub2e4 \uc57d\uac04\uc758 \ucc28\uc774\uac00 \uc788\ub294 \ud56d\ubaa9\uc774 \uc788\uc74c&#8230;<br><br>\ubc14\ub85c charset\uc744 \uc124\uc815\ud558\ub294 \ubd80\ubd84&#8230;<\/p>\n\n\n\n<p>\uc5b4\ub5a4 \uc18c\uac1c\uc790\ub8cc\uc5d0\uc11c\ub294<br>$pdo->exec(&#8220;set names utf8&#8221;)<br>\uc774\ub807\uac8c \uc124\uba85\uc744 \ud558\uae30\ub3c4 \ud558\uace0<br><br>\uc5b4\ub5a4 \uc18c\uac1c\uc790\ub8cc\uc5d0\uc11c\ub294<br>&#8220;charset=utf8&#8221;<br>\uc774\ub7f0 \ud615\ud0dc\ub85c&#8230;<\/p>\n\n\n\n<p>\ub450 \uc0ac\ub840\uc758 \uacb0\uacfc\ub294 \ub3d9\uc77c\ud558\uc9c0\ub9cc &#8220;\uc65c \uc774\ub807\uac8c \ud574\uc57c \ud558\ub294\uac00?&#8221; \ud558\ub294 \uc758\ubb38\uc774 \ub4e4\uc5c8\uc74c<br>\uadf8\ub798\uc11c \ucc3e\uc544\ubcf4\ub2c8<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>PHP-5.3.6 \uc774\uc804 \ubc84\uc804\uc5d0\uc11c\ub294 charset \uc635\uc158\uc774 \uc801\uc6a9\ub418\uc9c0 \uc54a\ub294 \ubb38\uc81c\uac00 \uc788\uc5c8\uae30 \ub54c\ubb38\uc5d0<br>$pdo->exec(&#8220;set names utf8&#8221;)<br>\uc694\ub7f0\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud574\uc654\uc74c<\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc \uc774\ud6c4 \ubc84\uc804\uc5d0\uc11c\ub294 \ud574\uacb0\ub418\uc5b4<br>\uc811\uc18d \uc120\uc5b8 \ud30c\ub77c\ubbf8\ud130\uc5d0<br>$pdo = new PDO(&#8220;mysql:host=$host;dbname=$db;charset=utf8&#8221;, $user, $pass);<br>\uc989, &#8220;charset=utf8&#8221; \uc635\uc158\uc744 \ucd94\uac00\ud574 \uc8fc\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\ub294\uac83&#8230; <\/p>\n\n\n\n<p>\uad6c\ubc84\uc804(php-5.3.6\uc774\uc804)\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74 \uc804\uc790\uc758 \uacbd\uc6b0\ub97c.. <br>\uc774\ud6c4 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74(\ud558\uae34&#8230; \uc694\uc998 7.X \uae4c\uc9c0 \ub098\uc640\uc788\uc73c\ub2c8) \ud6c4\uc790\uc758 \uacbd\uc6b0\ub97c<\/p>\n\n\n\n<p>\uc0ac\uc6a9\ud558\uba74 \ub418\uaca0\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>pdo_mysql \uae30\ubc18\uc758 DB\ucee4\ub125\uc158\uc744 \ucc3e\ub2e4\ubcf4\ub2c8\uc18c\uac1c\ud558\ub294 \uae00\ub9c8\ub2e4 \uc57d\uac04\uc758 \ucc28\uc774\uac00 \uc788\ub294 \ud56d\ubaa9\uc774 \uc788\uc74c&#8230; \ubc14\ub85c charset\uc744 \uc124\uc815\ud558\ub294 \ubd80\ubd84&#8230; \uc5b4\ub5a4 \uc18c\uac1c\uc790\ub8cc\uc5d0\uc11c\ub294$pdo->exec(&#8220;set names utf8&#8221;)\uc774\ub807\uac8c \uc124\uba85\uc744 \ud558\uae30\ub3c4 \ud558\uace0 \uc5b4\ub5a4 \uc18c\uac1c\uc790\ub8cc\uc5d0\uc11c\ub294&#8220;charset=utf8&#8221;\uc774\ub7f0 \ud615\ud0dc\ub85c&#8230; \ub450 \uc0ac\ub840\uc758 \uacb0\uacfc\ub294 \ub3d9\uc77c\ud558\uc9c0\ub9cc &#8220;\uc65c \uc774\ub807\uac8c \ud574\uc57c \ud558\ub294\uac00?&#8221; \ud558\ub294 \uc758\ubb38\uc774 \ub4e4\uc5c8\uc74c\uadf8\ub798\uc11c \ucc3e\uc544\ubcf4\ub2c8 PHP-5.3.6 \uc774\uc804 \ubc84\uc804\uc5d0\uc11c\ub294 charset \uc635\uc158\uc774 \uc801\uc6a9\ub418\uc9c0 \uc54a\ub294 \ubb38\uc81c\uac00 \uc788\uc5c8\uae30 \ub54c\ubb38\uc5d0$pdo->exec(&#8220;set names utf8&#8221;)\uc694\ub7f0\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud574\uc654\uc74c \ud558\uc9c0\ub9cc \uc774\ud6c4 \ubc84\uc804\uc5d0\uc11c\ub294 \ud574\uacb0\ub418\uc5b4\uc811\uc18d \uc120\uc5b8 \ud30c\ub77c\ubbf8\ud130\uc5d0$pdo = new PDO(&#8220;mysql:host=$host;dbname=$db;charset=utf8&#8221;, $user, $pass);\uc989, &#8220;charset=utf8&#8221; \uc635\uc158\uc744 \ucd94\uac00\ud574 \uc8fc\uba74 \ub41c\ub2e4. \ub294\uac83&#8230; \uad6c\ubc84\uc804(php-5.3.6\uc774\uc804)\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74 \uc804\uc790\uc758 \uacbd\uc6b0\ub97c.. \uc774\ud6c4 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74(\ud558\uae34&#8230; \uc694\uc998 7.X \uae4c\uc9c0 \ub098\uc640\uc788\uc73c\ub2c8) \ud6c4\uc790\uc758 \uacbd\uc6b0\ub97c \uc0ac\uc6a9\ud558\uba74 \ub418\uaca0\ub2e4.<\/p>\n<\/div>","protected":false},"author":1,"featured_media":923,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[691],"tags":[498,1398],"class_list":["post-30150","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev","tag-mysql","tag-pdo_mysql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/30150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/comments?post=30150"}],"version-history":[{"count":1,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/30150\/revisions"}],"predecessor-version":[{"id":30152,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/30150\/revisions\/30152"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media\/923"}],"wp:attachment":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media?parent=30150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/categories?post=30150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/tags?post=30150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}