{"id":199,"date":"2006-11-14T15:07:56","date_gmt":"2006-11-14T15:07:56","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=199"},"modified":"2017-01-29T14:21:45","modified_gmt":"2017-01-29T05:21:45","slug":"%eb%84%88-%eb%98%90%eb%9d%bc%ec%9d%b4%ec%a7%80","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=199","title":{"rendered":"\ub108 &#8220;\ub610\ub77c\uc774&#8221;\uc9c0?"},"content":{"rendered":"<p dir=\"ltr\" style=\"margin-right: 0px\">\uc624\ub298 \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \uc54c\uace0 \ub0b4\uac00 \ub098\ud55c\ud14c \ub358\uc9c4 \ub9d0\uc774\ub2e4.<\/p>\n<p>&#8220;\ub108.. \ub610\ub77c\uc774\uc9c0?&#8221; \u314b\u314b<\/p>\n<p>\ubb38\uc81c\ub294 MySQL\uc5d0\uc11c BLOB Type\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud55c \ud6c4\uc5d0 \uc77d\uc5b4\ubcf4\ub2c8 \uc804\uccb4 \ub370\uc774\ud130\uac00 \uc544\ub2cc \uc77c\ubd80\ub9cc \uc77d\ud600\uc9c0\ub294 \uac83\uc774\uc600\ub2e4. \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c \uadf8\ub9bc\ud30c\uc77c\uc758 \ud06c\uae30\ub294 195,881KB. \uadf8\ub7f0\ub370 \uc77d\ud600\uc9c0\ub294 \ub370\uc774\ud130 \uae38\uc774\ub294 65,535KB. \uc800\uc7a5\ud560\ub54c \uc798\ubabb\ub41c \uac74\uc9c0.. \uc77d\uc5b4\uc62c\ub54c \uc798\ubabb\ub41c \uac83\uc778\uc9c0 \uace0\ubbfc\ud558\ub2e4\uac00 \uc774\uac83\uc800\uac83.. MySQL \ud658\uacbd\uc124\uc815 \ud30c\uc77c\ub3c4 \uac74\ub4dc\ub824 \ubcf4\uace0 \ub9d0\uc774\ub2e4. \ud658\uacbd\uc124\uc815 \ud30c\uc77c\uc744 \ubcf4\uace0 MySQL&#8230; \uc774\uac70 \uc81c\ub300\ub85c \uc4f8\ub77c\uba74 \uacf5\ubd80\ud560\uac70 \ub108\ubb34 \ub9ce\uc740\uac83 \uac19\ub2e4.. \ub77c\ub294 \ubd80\ub2f4\uc2a4\ub7f0 \uc0dd\uac01\ub3c4 \ub4e4\uace0&#8230; \ubb50 \uc5ec\ud2bc&#8230; \uc544\ubb34\ub9ac \uc778\ud130\ub137\uc744 \ucc3e\uc544\ubd10\ub3c4 BLOB \ub370\uc774\ud130\uac00 \uc804\ubd80 \uc624\uc9c0 \uc54a\ub294 \uc774\uc720\ub294 \ucc3e\uc744 \uc218\uac00 \uc5c6\uc5c8\ub2e4. \uad6c\uae00\uc2e0\uc5d0\uac8c \ub3c4\uc6c0\uc744 \uc694\uccad\ud574\ub3c4 \uc5c6\ub2e4\ub294\uac74&#8230;. \ubb54\uac00 \uc774\uc720\uac00 &#8220;\uc5bc\ud1a0\ub2f9\ud1a0&#8221; \uc54a\uc740 \uac83\uc774\ub77c\ub294 \ud655\uc728\uc774 90%\uc774\uc0c1\uc774\ub780 \ub9d0\uc778\ub370&#8230; \ud558\uc9c0\ub9cc \uc5ec\uc804\uc774 \ub098\ub294 &#8220;MySQL \uc774\ub188\uc774 \ubd84\uba85\uc774 BLOB \ub370\uc774\ud130\uc758 \ud06c\uae30\ub97c \uc81c\ud55c\ud558\uace0 \uc788\ub294\uac8c \ubd84\uba85\ud574. \ubd10&#8230; 65,535KB\ub9cc \ubcf4\ub0b4\uc8fc\uc794\uc544? \uc989, 64K\ub9cc \ubcf4\ub0b4\uc8fc\uace0 \uc788\ub2e4\uad6c.. \ubd84\uba85 \ud658\uacbd\uc124\uc815\uc5d0\uc11c \uc804\uc1a1 \ud06c\uae30\ub97c \ub298\ub824\uc8fc\ub294 \ud658\uacbd\ubcc0\uc218\uac00 \uc788\uc744 \uac83\uc774\uace0 \uadf8\uac83\ub9cc \ub298\ub824\uc8fc\uba74 \ub420\uac83\uc57c..&#8221;\ub77c\uace0 \ud655\uc2e0\ud558\uba70 \uadf8\ub2e4\uc9c0 \ud765\ubbf8\ub86d\uc9c0 \uc54a\uc740 MySQL \ud658\uacbd \ubcc0\uc218\ub9cc\uc744 \ub4a4\uc9c0\uae30 \uc2dc\uc791\ud588\uc73c\ub098.. \ub3c4\ub300\uccb4 \uc774\ub188\uc774\ub2e4 \uc2f6\uc740 \ub188\uc774 \uc5c6\uc5c8\ub2e4. \uc74c&#8230; \ud639\uc2dc BLOB\uc758 \ucd5c\ub300 \ud06c\uae30\uac00 64KB\uc544\ub0d0? \ub77c\ub294 \uc0dd\uac01\uc5d0 \ucc3e\uc544\ubcf4\ub2c8 \uadf8\ub0e5 BLOB\ub9cc \uc788\ub294\uac8c \uc544\ub2c8\ub77c TINYBLOB, MEDIUMBLOB, LONGBLOB \ub77c\ub294 Type\ub3c4 \uc788\ub294\uac8c \uc544\ub2cc\uac00.. \uac01\uac01\uc758 \ucd5c\ub300 \ud06c\uae30\ub97c \ubcf4\ub2c8\uae4c<\/p>\n<ul>\n<li>BLOB\ub294 2^16-1KB\n<li>TINYBLOB\ub294 2^8-1KB\n<li>MEDIUMBLOB\ub294 2^24-1KB\n<li>LONGBLOB\ub294 2^32-1KB<\/li>\n<\/ul>\n<p>\uc600\ub2e4. \ubd10.. \ub2e4 <font color=\"#ff7635\" size=\"3\"><strong>&#8220;65,535KB\ubcf4\ub2e4 \ud06c\uc794\uc544..&#8221;<\/strong><\/font>\ub77c\uace0 \uc790\uc2e0\uc788\uac8c \ud655\uc2e0\ud55c \ud6c4\uc5d0, \uc5ed\uc2dc \uc6d0\uc778\uc740 MySQL\uc758 \ud658\uacbd\ubcc0\uc218\uc5d0 \uc788\uc5b4 \ud558\uace0 \uc788\ub294\ub370..&nbsp; \uadfc\ub370 2^16\uc774 \uba87\uc774\uc9c0? \ub77c\ub294 \uc0dd\uac01\uc5d0 \uacc4\uc0b0\uae30\ub97c \ub69c\ub4dc\ub824\ubcf4\ub2c8.. 2^16 = 65536 !! \uc73c\uc544~~ \u315c_\u315c \uc800 \ub610\ub77c\uc774 \ub9de\uc8e0? \u3160_\u315c \uadf8\ub370 \uc4f0\uace0\ubcf4\ub2c8 \ub610\ub77c\uc774\ub294 \uc880 \uc2ec\ud588\ub2e4\ub294 \uc0dd\uac01\uc5d0 \ub610 \ub2e4\uc2dc \u3160_\u3160 <\/p>\n<p>\ub098 \uc774\uc81c \ud1f4\uadfc\ud560\ub798.. \uc9c0\ud558\ucca0 \ub04a\uae30\uae30 \uc804\uc5d0~<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub298 \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \uc54c\uace0 \ub0b4\uac00 \ub098\ud55c\ud14c \ub358\uc9c4 \ub9d0\uc774\ub2e4. &#8220;\ub108.. \ub610\ub77c\uc774\uc9c0?&#8221; \u314b\u314b \ubb38\uc81c\ub294 MySQL\uc5d0\uc11c BLOB Type\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud55c \ud6c4\uc5d0 \uc77d\uc5b4\ubcf4\ub2c8 \uc804\uccb4 \ub370\uc774\ud130\uac00 \uc544\ub2cc \uc77c\ubd80\ub9cc \uc77d\ud600\uc9c0\ub294 \uac83\uc774\uc600\ub2e4. \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c \uadf8\ub9bc\ud30c\uc77c\uc758 \ud06c\uae30\ub294 195,881KB. \uadf8\ub7f0\ub370 \uc77d\ud600\uc9c0\ub294 \ub370\uc774\ud130 \uae38\uc774\ub294 65,535KB. \uc800\uc7a5\ud560\ub54c \uc798\ubabb\ub41c \uac74\uc9c0.. \uc77d\uc5b4\uc62c\ub54c \uc798\ubabb\ub41c \uac83\uc778\uc9c0 \uace0\ubbfc\ud558\ub2e4\uac00 \uc774\uac83\uc800\uac83.. MySQL \ud658\uacbd\uc124\uc815 \ud30c\uc77c\ub3c4 \uac74\ub4dc\ub824 \ubcf4\uace0 \ub9d0\uc774\ub2e4. \ud658\uacbd\uc124\uc815 \ud30c\uc77c\uc744 \ubcf4\uace0 MySQL&#8230; \uc774\uac70 \uc81c\ub300\ub85c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=199\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;\ub108 &#8220;\ub610\ub77c\uc774&#8221;\uc9c0?&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-199","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=199"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/199\/revisions"}],"predecessor-version":[{"id":3706,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/199\/revisions\/3706"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}