{"id":442,"date":"2013-01-09T11:20:48","date_gmt":"2013-01-09T02:20:48","guid":{"rendered":"http:\/\/www.freesens.com\/x\/?p=442"},"modified":"2013-01-09T11:20:48","modified_gmt":"2013-01-09T02:20:48","slug":"oracle-characterset-%ed%99%95%ec%9d%b8","status":"publish","type":"post","link":"http:\/\/www.freesens.com\/x\/?p=442","title":{"rendered":"oracle characterset \ud655\uc778."},"content":{"rendered":"<p>ORA-29275<br \/>\n\uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 characterset\uc774 \uc0c1\uc774\ud55c \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd\ud55c\ub2e4\uace0 \ud558\ub294\ub370&#8230;\uc774 \uacbd\uc6b0\uc5d0\ub294 \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc11c\ubc84\uce21\uc758 characterset\uc744 \ud655\uc778\ud574\uc11c client\uc758 characterset\uc744 \ubcc0\uacbd\ud558\uac70\ub098&#8230;..\uc544\ub2c8\uba74 \uc11c\ubc84\uce21\uc758 characterset\uc744 \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc73c\ub098&#8230;.\uc11c\ubc84\uce21\uc758 characterset\uc744 \ubcc0\uacbd\ud558\uba74 \ud574\ub2f9 DB\uc5d0 \uc811\uadfc\ud558\ub294 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\ub4e4\uc774 \ub85c\uceec \ud658\uacbd\uc5d0\uc11c characterset\uc744 \ubcc0\uacbd\ud574\uc57c \ud558\ub2c8, \uc11c\ubc84\uce21\uc758 characterset\uc744 \ud655\uc778\ud558\uace0 \uc790\uc2e0\uc758 \ub85c\uceec \uce90\ub9ad\ud130\uc14b\uc744 \ubcc0\uacbd\ud558\ub294\uac8c \uc815\uc2e0 \uac74\uac15\uc5d0 \uc774\ub86d\ub2e4.<\/p>\n<div style=\"border-top: 1px dashed #cccccc; border-bottom: 1px dashed #cccccc; background: #f7f7f7; padding: 10px;\">\n<pre>select *\r\n  from nls_database_parameters\r\n where parameter like '%CHARACTERSET%'<\/pre>\n<\/div>\n<p>\uc704\uc758 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud574\ubcf4\uba74 NLS_CHARACTERSET \uc774 \uc870\ud68c\ub418\ub294\ub370, \uc774\uac8c \uc11c\ubc84\uc5d0 \ud604\uc7ac \uc124\uc815\ub41c \uce90\ub9ad\ud130\uc14b\uc774\ub2c8, \uc774\ub300\ub85c \ub85c\uceec \ud658\uacbd\uc744 \uc124\uc815\uc744 \ubcc0\uacbd\ud574\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n<p>\uac1c\uc778\uc801\uc73c\ub85c Windows 7 64bit \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uad00\uacc4\ub85c regedit\ub85c \ub808\uc9c0\uc2a4\ud2b8\ub9ac \ud3b8\uc9d1\uae30\ub97c \uc2e4\ud589\ud558\uba74 \uc544\ub798 \uacbd\ub85c\uc5d0\uc11c NLS_LANG\uc758 \uac12\uc744 \uc11c\ubc84\uce21\uacfc \ub3d9\uc77c\ud558\uac8c \ubcc0\uacbd\ud574\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n<p>HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE\\KEY_OraClient11g_home1<br \/>\n32bit OS\ub97c \uc0ac\uc6a9\uc911\uc774\ub77c\uba74 Wow6432Node\uac00 \uc5c6\uace0, SOFTWARE\ubc14\ub85c \uc544\ub798\uc5d0 ORACLE\uc774 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n<p>\uc11c\ubc84\uce21\uc758 NLS_CHARACTERSET\uc5d0 UTF8 \uc774\ub77c\uba74 NLS_LANG \uac12\uc744.. KOREAN_KOREA.UTF8 \ucc98\ub7fc \ubcc0\uacbd\ud558\uba74 \ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc624\ub77c\ud074 \uc5d0\ub7ec\ucf54\ub4dc\ub9cc \ubcf4\uace0 \uac80\uc0c9\uc744 \ud558\uba74 \uc704\uc640 \uac19\uc740 \ub0b4\uc6a9\uc774 \ub300\ubd80\ubd84\uc774\uace0&#8230; \uc2e4\uc81c\ub85c \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc5d0 characterset\uc774 \uc77c\uce58\ud568\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 \uacc4\uc18d \ub3d9\uc77c\ud55c \uc5d0\ub7ec\ucf54\ub4dc\ub97c \ubc18\ud658\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \uceec\ub7fc \ub0b4\ubd80\uc5d0 \ud574\ub2f9 characterset\uc73c\ub85c \uc778\uc2dd\uc774 \uc548\ub418\ub294 \ubb38\uc790\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0\ub77c \ubcfc \uc218 \uc788\ub2e4.<\/p>\n<p>\uc77c\ub2e8 \uc5b4\ub5a4 \uceec\ub7fc\uc5d0 \ub370\uc774\ud130\uac00 \ubb38\uc81c\uc778\uc9c0\ub97c \ucc3e\uae30 \uc704\ud574, \ud14c\uc774\ube14 \ub0b4 \uceec\ub7fc\uc911 \uc758\uc2ec\ub418\ub294 \uceec\ub7fc\ub9cc \uc81c\uc678\ud558\uace0 \uc870\ud68c\ub97c \ud574\uc11c \uc815\uc0c1\uc801\uc73c\ub85c \uc870\ud68c\uac00 \uc548\ub418\ub294 \uceec\ub7fc\uba85\uc744 \ucc3e\uace0&#8230;&#8230; \uadf8 \ub2e4\uc74c\uc73c\ub85c \ub300\ub7b5\uc801\uc778 \uc870\uac74\uc73c\ub85c \uc870\ud68c\uac74\uc218\ub97c \uc870\uc808\ud574\uc11c \ubb38\uc81c\uac00 \ub418\ub294 row\ub97c \ucc3e\uc544\uc11c \ud574\ub2f9 \uceec\ub7fc\uc758 \uac12\uc744 update\uc2dc\ud0a4\uac70\ub098, \uc0ad\uc81c\ud558\uba74&#8230;\uc798 \uc791\ub3d9\ud568.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ORA-29275 \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 characterset\uc774 \uc0c1\uc774\ud55c \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd\ud55c\ub2e4\uace0 \ud558\ub294\ub370&#8230;\uc774 \uacbd\uc6b0\uc5d0\ub294 \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc11c\ubc84\uce21\uc758 characterset\uc744 \ud655\uc778\ud574\uc11c client\uc758 characterset\uc744 \ubcc0\uacbd\ud558\uac70\ub098&#8230;..\uc544\ub2c8\uba74 \uc11c\ubc84\uce21\uc758 characterset\uc744 \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc73c\ub098&#8230;.\uc11c\ubc84\uce21\uc758 characterset\uc744 \ubcc0\uacbd\ud558\uba74 \ud574\ub2f9 DB\uc5d0 \uc811\uadfc\ud558\ub294 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\ub4e4\uc774 \ub85c\uceec \ud658\uacbd\uc5d0\uc11c characterset\uc744 \ubcc0\uacbd\ud574\uc57c \ud558\ub2c8, \uc11c\ubc84\uce21\uc758 characterset\uc744 \ud655\uc778\ud558\uace0 \uc790\uc2e0\uc758 \ub85c\uceec \uce90\ub9ad\ud130\uc14b\uc744 \ubcc0\uacbd\ud558\ub294\uac8c \uc815\uc2e0 \uac74\uac15\uc5d0 \uc774\ub86d\ub2e4. select * from nls_database_parameters where parameter like &#8216;%CHARACTERSET%&#8217; \uc704\uc758 &hellip; <a href=\"http:\/\/www.freesens.com\/x\/?p=442\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">oracle characterset \ud655\uc778.<\/span> <span class=\"meta-nav\">&rarr;<\/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":[17],"tags":[59,60,24,28],"class_list":["post-442","post","type-post","status-publish","format-standard","hentry","category-etc","tag-db","tag-ora-29275","tag-oracle","tag-28"],"_links":{"self":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=442"}],"version-history":[{"count":1,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions"}],"predecessor-version":[{"id":443,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions\/443"}],"wp:attachment":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}