{"id":2710,"date":"2018-02-02T22:39:04","date_gmt":"2018-02-02T13:39:04","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2710"},"modified":"2018-02-02T22:42:12","modified_gmt":"2018-02-02T13:42:12","slug":"2710","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2710","title":{"rendered":"\ud55c\uae00\uc774 ??? \ub85c DISPLAY \ub418\ub294 \uacbd\uc6b0"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

ORACLE TOOLS(SQLPLUS,\ub4f1)\uc744 \uc774\uc6a9\ud558\uc5ec \ud55c\uae00DATA\ub97c \uc870\ud68c\ud560 \ub54c ???\ub85c \ucd9c\ub825\ub294\ub370 \ud574\uacb0 \ubc29\ubc95<\/p>\n

======================================================================================<\/p>\n

DATABASE\ub294 SQL COMMAND ‘CREATE DATABASE’\ub97c \ud3ec\ud568\ud558\ub294 STATEMENT\ub97c \uc218\ud589\ud560 \ub54c \ub9cc\ub4e4\uc5b4\uc9c0\ub294\ub370 \uc6b0\ub9ac\uac00 \uadf8STATEMENT\ub97c \uc218\ud589\ud558\uae30 \uc55e\uc11c \uace0\ub824\ud574\uc57c \uc0ac\ud56d\uc911\uc758 \ud558\ub098\uac00 DB CHARACTERSET \uc774\ub2e4.<\/p>\n

DB\ub97c CREATE\ud560\ub54c DATABSE CHARACTERSET\uc744 \uba85\uc2dc\ud574\uc57c\ub9cc \ud558\ub294\ub370 \ud55c\ubc88 \uc120\ud0dd\ub418\uace0 \ub09c\ud6c4\uc5d0\ub294 CHARACTERSET \uc744 \ubcc0\uacbd\ud558\ub294 \uac83\uc740 \uc27d\uc9c0\uac00 \uc54a\ub2e4.<\/p>\n

DATA DICTIONARY\uc5d0 \uc788\ub294 DATA\ub97c \ud3ec\ud568\ud574\uc11c \ubaa8\ub4e0 DATA\ub294 \uc120\ud0dd\ub41c CHARACTERSET \uc5d0 \uc758\ud574 \uc785\ucd9c\ub825 \ub418\uae30 \ub54c\ubb38\uc5d0 USER\uac00 \ub2e4\ub978 CHARATERSET\uc73c\ub85c ACCESS\ud55c\ub2e4\uba74 \ud55c\uae00 \ub370\uc774\ud0c0\uac00 ???\ub85c \ucd9c\ub825\ub41c\ub2e4.<\/p>\n

\ub610\ud55c \ubd84\uc0b0 DB \ud658\uacbd\uc5d0\uc11c\ub098 UPGRADE\ud560 \uacbd\uc6b0\uc5d0\ub294 DATABASE CHARACTERSET\uc774 \uac19\uc544\uc57c \ud568\uc73c\ub85c \uc0ac\uc6a9\uc790\ub4e4\uc740 DATABASE\uc758 CHARACTERSET\uc744 \uc54c\uc544\uc544 \ub450\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

 <\/p>\n

< \ud604\uc7ac DATABASE \uc758 CHARACTERSET \ud655\uc778 \ubc0f \ubcc0\uacbd ><\/p>\n

 <\/p>\n

1. \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 CHARACTERSET \ud655\uc778<\/p>\n

$ sqldba lmode=y<\/p>\n

SQL> connect internal<\/p>\n

SQL> select * from v$nls_parameters;<\/p>\n

PARAMETER VALUE<\/p>\n

—————————— ————–<\/p>\n

….<\/p>\n

NLS_CHARACTERSET KO16KSC5601 (or US7ASCII)<\/p>\n

(A)<\/p>\n

 <\/p>\n

2. \ud658\uacbd \ubcc0\uc218\uc758 NLS_LANG \ud655\uc778<\/p>\n

$ env<\/p>\n

…<\/p>\n

NLS_LANG=American_America.US7ASCII<\/p>\n

(B)<\/p>\n

 <\/p>\n

\uc704\uc758 (A)\uc640 (B) \uac00 \ub3d9\uc77c \ud574\uc57c\ub9cc \ud55c\uae00 \ub370\uc774\ud0c0 \ucc98\ub9ac\uac00 \uc798\ub418\uace0 \uc11c\ub85c \ub2e4\ub978 \uc0c1\ud0dc\uc5d0\uc11c \ud55c\uae00 \ub370\uc774\ud0c0\ub97c \uc870\ud68c \ud560\uacbd\uc6b0 ??? \ub85c \ucd9c\ub825 \ub41c\ub2e4.<\/span><\/p>\n

 <\/p>\n

3. CHARACTERSET \uc744 \uc77c\uce58 \uc2dc\ud0a4\ub294 \ubc29\ubc95<\/p>\n

* NLS_LANG \ud658\uacbd \ubcc0\uc218\ub97c \ubcc0\uacbd\ud558\uc5ec \uc77c\uce58\uc2dc\ud0a4\ub294 \ubc29\ubc95<\/p>\n

Bourne shell, k-shell \uc744 \uc0ac\uc6a9 \ud558\ub294\uacbd\uc6b0 . profile \uc744 \uc218\uc815<\/p>\n

NLS_LANG = American_Amerca.KO16KSC5601; export NLS_LANG<\/p>\n

c-chell \uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 .cshrc \ud639\uc740 .login \uc218\uc815<\/p>\n

setenv NLS_LANG American_America.KO16KSC5601<\/p>\n

\uc218\uc815\ud6c4 \ub2e4\uc2dc $ env \ub97c \uc2e4\ud589\ud558\uc5ec \ubcc0\uacbd \ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n

C:\\WINDOWS\\ORACLE.INI \uc218\uc815<\/p>\n

NLS_LANG=American_America.KO16KSC5601<\/p>\n

WINDOW \uc7ac\uae30\ub3d9<\/p>\n

* \uadf8\ub9ac\uace0 \uc608\ub97c \ub4e4\uc5b4\uc11c SERVER\uc758 character set\uc774 US7ASCII \uc774\uace0 PC\uc758 NLS_LANG\uc774<\/p>\n

American_America.KO16KSC5601 \uacfc \uac19\uc774 \uc11c\ub85c \ub2e4\ub974\uac8c \uc124\uc815\ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0 \ub2e4\uc74c\uc744 \ud558\ub098 \ub354<\/p>\n

oracle.ini\uc5d0 \ucd94\uac00\ud558\uba74 \ud55c\uae00\ubb38\uc81c\uac00 \ud574\uacb0\ub429\ub2c8\ub2e4.<\/p>\n

ORA_NLS_CHARACTERSET_CONVERSION=NO_CHARACTER_SET_CONVERSION<\/p>\n

WINDOWS 95\uc5d0\uc11c\ub294 NLS_LANG\uc774 ORACLE.INI\uc5d0 \ub4e4\uc5b4 \uc788\uc9c0 \uc54a\uace0 REGISTRY\uc5d0 \uae30\ub85d\ub418\ubbc0\ub85c REGISTRY<\/p>\n

EDITOR\ub97c \uc774\uc6a9\ud558\uc5ec \uc218\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n

MSDOS \ucc3d\uc73c\ub85c \ub098\uac00\uc11c REGEDIT.EXE \uc0d0\ud589<\/p>\n

HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE \uc120\ud0dd<\/p>\n

\uc624\ub978\ucabd \ub9c8\uc6b0\uc2a4 \ubc84\ud2bc\uc744 \uc774\uc6a9\ud558\uc5ec NLS_LANG\uc744 \uc218\uc815<\/p>\n

REGISTRY \ubcc0\uacbd \ud6c4\uc5d0 PC\ub97c REBOOTING \ud560 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n

WINDOWS NT \uc5d0\uc11c\ub3c4 WINDOWS 95\uc758 \uacbd\uc6b0\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c REGISTRY \uc5d0 \uae30\ub85d\ub41c \uc815\ubcf4\ub97c \ubcc0\uacbd\ud574 \uc8fc\uba74<\/p>\n

\ub429\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc774 \ud569\ub2c8\ub2e4.<\/p>\n

DOS \ucc3d\uc5d0\uc11c REGEDT32.EXE \uc2e4\ud589<\/p>\n

HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE \uc120\ud0dd<\/p>\n

\uba54\ub274\ub97c \uc120\ud0dd\ud558\uc5ec NLS_LANG\uc744 \uc218\uc815<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

ORACLE TOOLS(SQLPLUS,\ub4f1)\uc744 \uc774\uc6a9\ud558\uc5ec \ud55c\uae00DATA\ub97c \uc870\ud68c\ud560 \ub54c ???\ub85c \ucd9c\ub825\ub294\ub370 \ud574\uacb0 \ubc29\ubc95 ====================================================================================== DATABASE\ub294 SQL COMMAND ‘CREATE DATABASE’\ub97c \ud3ec\ud568\ud558\ub294 STATEMENT\ub97c \uc218\ud589\ud560 \ub54c \ub9cc\ub4e4\uc5b4\uc9c0\ub294\ub370 \uc6b0\ub9ac\uac00 \uadf8STATEMENT\ub97c \uc218\ud589\ud558\uae30 \uc55e\uc11c \uace0\ub824\ud574\uc57c \uc0ac\ud56d\uc911\uc758 \ud558\ub098\uac00 DB CHARACTERSET \uc774\ub2e4. DB\ub97c CREATE\ud560\ub54c DATABSE CHARACTERSET\uc744 \uba85\uc2dc\ud574\uc57c\ub9cc \ud558\ub294\ub370 \ud55c\ubc88 \uc120\ud0dd\ub418\uace0 \ub09c\ud6c4\uc5d0\ub294 CHARACTERSET \uc744 \ubcc0\uacbd\ud558\ub294 \uac83\uc740 \uc27d\uc9c0\uac00 \uc54a\ub2e4. DATA DICTIONARY\uc5d0 \uc788\ub294 DATA\ub97c \ud3ec\ud568\ud574\uc11c \ubaa8\ub4e0 DATA\ub294 \uc120\ud0dd\ub41c CHARACTERSET […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[899,897,898],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2710"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2710"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2710\/revisions"}],"predecessor-version":[{"id":2714,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2710\/revisions\/2714"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2710"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}