{"id":1338,"date":"2013-07-23T15:55:49","date_gmt":"2013-07-23T15:55:49","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1338"},"modified":"2013-07-23T15:55:49","modified_gmt":"2013-07-23T15:55:49","slug":"mysql-%ed%95%9c%ea%b8%80%ec%84%a4%ec%a0%95-character-set-utf-8-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1338","title":{"rendered":"[mysql] \ud55c\uae00\uae68\uc9d0, \ud55c\uae00\uc124\uc815, Character set UTF-8 \uc124\uc815"},"content":{"rendered":"

\"\"<\/p>\n

Mysql \uc744 \uc124\uce58\ud558\uace0, db \ub97c \uc0dd\uc131\ud558\uace0, table \uc744 \ub9cc\ub4e4\uace0, \ub370\uc774\ud130\ub97c insert \ud588\ub294\ub370!!!!<\/p>\n

\uc774\ub7f0\uc2dd\uc73c\ub85c \ud55c\uae00\uc774 ??? \ub77c\uace0 \ub5a0\ubc84\ub838\uc2b5\ub2c8\ub2e4.<\/p>\n

\"\"<\/p>\n

utf-8 \ub85c \uc778\ucf54\ub529\ud574\uc11c \ub123\uc5b4\uc57c \ud558\ub098 \ub77c\uace0 \uc0dd\uac01\uc744 \ud588\ub2e4\uac00, \uc660\uc9c0 \uc880 \ub365\uc218\ub8e9(?)\ud55c \ubc29\ubc95 \uac19\uc544\uc11c \ucc3e\uc544\ubd24\uc5b4\uc694.<\/p>\n

mysql \uc758 character set \uc774 \uae30\ubcf8\uc801\uc73c\ub85c \uc124\uc815\ub418\uc5b4 \uc788\ub294\uac8c utf-8 \uc774 \uc544\ub2c8\ub77c \uc774\ub7f0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uace0 \ud558\ub124\uc694.<\/p>\n

mysql \uc758 \uce90\ub9ad\ud130\uc14b \uc124\uc815\uc744 \ubcc0\uacbd\ud574 \uc8fc\uc5b4\uc57c \uc774\ub7f0 \ud55c\uae00 \uae68\uc9d0 \ud604\uc0c1\uc744 \uc218\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uac04\ub2e8\ud558\uac8c \uc544\ub798 3\uac00\uc9c0 \uc815\ub3c4\uc758 \uc21c\uc11c\ub9cc \uac70\uce58\uba74 \ub418\ub354\ub77c\uad6c\uc694.<\/p>\n

1. my.cnf \uc218\uc815<\/p>\n

2. mysql \uc7ac\uc2dc\uc791<\/p>\n

3. \ud655\uc778 or \ud14c\uc774\ube14 \uce90\ub9ad\ud130 \uc14b \ubcc0\uacbd<\/p>\n\n\n\n
\u00a01. my.cnf \uc218\uc815<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ubcf4\ud1b5\uc758 \uacbd\uc6b0\uc5d0 my.cnf \ud30c\uc77c\uc740 \/etc \uc544\ub798\uc5d0 \uc788\ub098\ubd05\ub2c8\ub2e4.<\/p>\n

\uac1c\ubc1c\uc740 Mac OS \uc5d0\uc11c \ud558\uace0 \uc788\ub294\uc9c0\ub77c, \uc81c \uacbd\uc6b0\uc5d0\ub294 \/usr\/local\/mysql \uacbd\ub85c\uc5d0 \uc788\ub354\uad70\uc694.<\/p>\n

mysql \uc774 \uc124\uce58\ub41c \ud658\uacbd\uc5d0 \ub530\ub77c \uc704\uce58\ub294 \ub2e4\ub97c \uc218 \uc788\uc9c0\ub9cc, \uc798 \ucc3e\uc544\uac00\uc11c my.cnf \ud30c\uc77c\uc744 \uc5f4\uc5b4\uc11c \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud574\uc90d\ub2c8\ub2e4.<\/p>\n

[client] default-character-set=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci init_connect=SET collation_connection=utf8_general_ci init_connect=SET NAMES utf8 [mysql] default-character-set=utf8<\/span><\/pre>\n\n\n\n
\u00a02. mysql \uc7ac\uc2dc\uc791<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
mysql restart<\/p>\n
service mysql restart<\/p>\n
\ub4f1\uc758 \uba85\ub839\uc73c\ub85c mysql \uc744 \uc7ac\uc2dc\uc791 \ud574\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n
\u00a03. \ud655\uc778 or ALTER TABLE<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
mysql \uc5d0 \uc811\uc18d\ud574 status \uba85\ub839\uc73c\ub85c character set \uc774 \ubcc0\uacbd\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n
mysql> status<\/span><\/p>\n
\uc774\ub7f0\uc2dd\uc73c\ub85c mysql \uc758 \uc0c1\ud0dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\"\"<\/p>\n
\uc774\uc81c \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130\ub97c \ub123\uc5b4\uc11c \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4.<\/p>\n
\ub9cc\uc57d \uadf8\ub798\ub3c4 \uc81c\ub300\ub85c \ucd9c\ub825\uc774 \ub418\uc9c0\uc54a\uace0, \uae30\uc874\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \ubb3c\uc74c\ud45c\ub85c ??? \u00a0\ucd9c\ub825\ub41c\ub2e4\uba74, \ud14c\uc774\ube14\uc758 \uce90\ub9ad\ud130\uc14b\uc744 \ubcc0\uacbd\ud574\uc90d\ub2c8\ub2e4.<\/p>\n
mysql> ALTER TABLE table_name convert to charset utf8;<\/span><\/p>\n
\uc774\uc81c \ub2e4\uc2dc \ub370\uc774\ud130\ub97c \ub123\uc5b4\uc11c \ud655\uc778\ud574\ubd05\ub2c8\ub2e4. (\uc5ec\uae30\uae4c\uc9c0 \ud588\uc73c\uba74\u00a0\uc544\ub9c8) \uc815\uc0c1\uc801\uc73c\ub85c \ucd9c\ub825\uc774 \ub418\ub294\uac78 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ucd9c\ucc98 :\u00a0http:\/\/croute.me\/606<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Mysql \uc744 \uc124\uce58\ud558\uace0, db \ub97c \uc0dd\uc131\ud558\uace0, table \uc744 \ub9cc\ub4e4\uace0, \ub370\uc774\ud130\ub97c insert \ud588\ub294\ub370!!!! \uc774\ub7f0\uc2dd\uc73c\ub85c \ud55c\uae00\uc774 ??? \ub77c\uace0 \ub5a0\ubc84\ub838\uc2b5\ub2c8\ub2e4. utf-8 \ub85c \uc778\ucf54\ub529\ud574\uc11c \ub123\uc5b4\uc57c \ud558\ub098 \ub77c\uace0 \uc0dd\uac01\uc744 \ud588\ub2e4\uac00, \uc660\uc9c0 \uc880 \ub365\uc218\ub8e9(?)\ud55c \ubc29\ubc95 \uac19\uc544\uc11c… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1338"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1338"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1338\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}