{"id":11901,"date":"2022-10-02T21:43:33","date_gmt":"2022-10-02T12:43:33","guid":{"rendered":"https:\/\/prodskill.com\/?p=11901"},"modified":"2022-10-04T23:58:23","modified_gmt":"2022-10-04T14:58:23","slug":"oracle-character-set-migration-1-overview","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/","title":{"rendered":"Oracle Character Set Conversion(1): 1. Necessity, Correct Oracle Character Set Setup Guide"},"content":{"rendered":"<p>Review the need for Oracle Character Set conversion and a guide to setting up the correct character set.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p>In many next-generation projects, one of the thorny issues related to Data Migration (data migration, data migration, data migration) is Oracle&#039;s character set conversion.<\/p>\n\n\n\n<p>Most often it is a request to convert from an incorrect character set (eg US7ASCII) to a correct character set (eg KO16MSWIN949, AL32UTF8, etc.). In particular, the most problematic case is that the character set of the current DB is US7ASCII.<\/p>\n\n\n\n<p>Because data that is not stored normally is shown as normal data, many trials and errors are encountered in conversion.<\/p>\n\n\n\n<p>In the next few articles, I would like to share some tips and methods worth reviewing.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/#1_Oracle_Character_Set_%EB%B3%80%ED%99%98_%ED%95%84%EC%9A%94%EC%84%B1\" >1. Oracle Character Set Conversion Needs<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/#11_%EC%9E%98%EB%AA%BB_%EC%A7%80%EC%A0%95%EB%90%9C_Character_SetUS7ASCII\" >1.1. Incorrectly specified Character Set (US7ASCII)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/#12_%EC%B4%88%EA%B8%B0_%EA%B5%AD%EB%82%B4%ED%95%9C%EC%A0%95%EC%9C%BC%EB%A1%9C_%EA%B5%AC%EC%B6%95%EB%90%9C_%EC%8B%9C%EC%8A%A4%ED%85%9C%EC%9D%98_%EA%B8%80%EB%A1%9C%EB%B2%8C%ED%99%94\" >1.2. Globalization of the system that was initially limited to domestic<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/#2_%EC%98%AC%EB%B0%94%EB%A5%B8_Oracle_Character_Set_%EC%84%A4%EC%A0%95_%EA%B0%80%EC%9D%B4%EB%93%9C\" >2. Guide to Setting Up the Correct Oracle Character Set<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1._Oracle_Character_Set_\ubcc0\ud658_\ud544\uc694\uc131\"><span class=\"ez-toc-section\" id=\"1_Oracle_Character_Set_%EB%B3%80%ED%99%98_%ED%95%84%EC%9A%94%EC%84%B1\"><\/span>1. Oracle Character Set Conversion Needs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you want to convert Oracle Character Set, it is because the following requirements exist.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Incorrectly specified Character Set (US7ASCII)<\/li><li>Globalization of the initially built system limited to domestic (conversion from Korean character set to Unicode character set)<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.1._\uc798\ubabb_\uc9c0\uc815\ub41c_Character_Set(US7ASCII)\"><span class=\"ez-toc-section\" id=\"11_%EC%9E%98%EB%AA%BB_%EC%A7%80%EC%A0%95%EB%90%9C_Character_SetUS7ASCII\"><\/span>1.1. Incorrectly specified Character Set (US7ASCII)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>One of several important factors that determines when installing Oracle is the character set. After Oracle is installed, it is important to set it up well in the beginning because it is not easy to change it after the data is accumulated as the system is built and used.<\/p>\n\n\n\n<p>Among the response files required when installing Oracle in silent mode, the character set default value is set to \u201cUS7ASCII\u201d in the dbca.rsp file. It is commented out, and when installing, this setting must be accurately changed and entered. However, in the case of installation with just uncommenting due to mistake or negligence, the Character Set is designated as \u201cUS7ASCII\u201d.<\/p>\n\n\n\n<p>The following shows the default character set settings in the dbca.rsp file.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png\"><img loading=\"lazy\" decoding=\"async\" width=\"851\" height=\"529\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png\" alt=\"Oracle \uc744 silent mode\ub85c \uc124\uce58\ud560 \ub54c \ud544\uc694\ud55c response file\uc911 dbca.rsp \ud30c\uc77c Character set \uae30\ubcf8\uac12\" class=\"wp-image-11902\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png 851w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69-300x186.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69-768x477.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69-48x30.png 48w\" sizes=\"auto, (max-width: 851px) 100vw, 851px\" \/><\/a><figcaption>Among the response files required when installing Oracle in silent mode, the dbca.rsp file Character set default<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The situation that causes confusion here is that \u201cUS7ASCII\u201d also supports Korean input and output. It behaves as if it were to be spoken correctly. Even if Korean data is input, but it is not normally stored, it is possible to output Korean as if it were normal.<\/p>\n\n\n\n<p>However, since this is incomplete, unnecessary efforts such as Hangul conversion and processing logic in the application source code are required, and thus there is a possibility of causing an unintended error.<\/p>\n\n\n\n<p>For \u201cUS7ASCII\u201d, it is recommended to consider converting to \u201cKO16MSWIN949\u201d of Non-Unicode system or \u201cUTF8\u201d or \u201cAL32UTF8\u201d of Unicode system according to the purpose of the system.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.2._\ucd08\uae30_\uad6d\ub0b4\ud55c\uc815\uc73c\ub85c_\uad6c\ucd95\ub41c_\uc2dc\uc2a4\ud15c\uc758_\uae00\ub85c\ubc8c\ud654\"><span class=\"ez-toc-section\" id=\"12_%EC%B4%88%EA%B8%B0_%EA%B5%AD%EB%82%B4%ED%95%9C%EC%A0%95%EC%9C%BC%EB%A1%9C_%EA%B5%AC%EC%B6%95%EB%90%9C_%EC%8B%9C%EC%8A%A4%ED%85%9C%EC%9D%98_%EA%B8%80%EB%A1%9C%EB%B2%8C%ED%99%94\"><\/span>1.2. Globalization of the system that was initially limited to domestic<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If globalization is promoted through a next-generation project for a system in use with a character set of \u201cKO16KSC5601\u201d or \u201cKO16MSWIN949\u201d, conversion from Korean character set to Unicode character set is required.<\/p>\n\n\n\n<p>Since \u201cKO16KSC5601\u201d or \u201cKO16MSWIN949\u201d cannot store all multilingual characters, it must be converted to Unicode series \u201cUTF8\u201d or \u201cAL32UTF8\u201d.<\/p>\n\n\n\n<p>Since many domestic business environments are oriented toward globalization and the need to store multilingual characters cannot be completely excluded in the future, it is desirable to use Unicode-based character sets as much as possible.<\/p>\n\n\n\n<p>If the application is not built after installation or if the stored data can be discarded, it is recommended to reinstall from the beginning. It takes much less effort to reinstall than the effort required to change a character set, is faster, and safer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2._\uc62c\ubc14\ub978_Oracle_Character_Set_\uc124\uc815_\uac00\uc774\ub4dc\"><span class=\"ez-toc-section\" id=\"2_%EC%98%AC%EB%B0%94%EB%A5%B8_Oracle_Character_Set_%EC%84%A4%EC%A0%95_%EA%B0%80%EC%9D%B4%EB%93%9C\"><\/span>2. Guide to Setting Up the Correct Oracle Character Set<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The Oracle Character Set is divided into Non-Unicode series and Unicode series, and organized according to the relation of inclusion as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70.png\"><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"409\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70.png\" alt=\"Oracle Character Set \ud3ec\ud568\uad00\uacc4\" class=\"wp-image-11903\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70.png 901w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70-300x136.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70-768x349.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70-36x16.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-70-48x22.png 48w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/a><figcaption>Oracle Character Set Inclusion Relationships<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(\u201cUS7ASCII\u201d is not a Unicode family, but is included and expressed as a subset of UTF8.)<\/p>\n\n\n\n<p>To set up the Oracle Character Set correctly, simply choose one of the following two options:<\/p>\n\n\n\n<figure class=\"wp-block-table\" style=\"font-size:15px\"><table><tbody><tr><td>system type<\/td><td>Recommended Character Set<\/td><td>Explanation<\/td><\/tr><tr><td>System used only in Korea<\/td><td>KO16MSWIN949<\/td><td>\u2013 All characters that can be input through the Korean IME in Korean Windows can be supported (Korean, Chinese characters, English, numbers, etc.)<br>\u2013 Hangul and Chinese characters are stored as 2 bytes, and English and numbers are stored as 1 byte.<\/td><\/tr><tr><td>Systems that need to store multilingual characters<\/td><td>AL32UTF8<\/td><td>\u2013 AL32UTF8 can support all characters added in the latest Unicode (Chinese characters, Western European characters, Southeast Asian characters, etc.)<br>\u2013 English letters and numbers are stored in 1 byte, and most of the other characters are stored in 3 bytes. (Some characters are stored as 4 bytes, but they are rarely used.)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Compared to \u201cKO16MSWIN949\u201d, \u201cAL32UTF8\u201d requires a maximum of 1.5 times the storage space for character types (when only Korean characters are included), but there are data (code, ID, number, sequence number, etc.) that only use English\/numbers, and Korean and English characters. \/Since there are many cases where the numbers are mixed, it is not accurate, but generally it can be seen that the storage space increases by 1.3 times.<\/p>\n\n\n\n<p>For details on each character set, please refer to the following.<\/p>\n\n\n\n<p>*Source: Looking into the perfect compatibility between Oracle and NLS (Ryu Jung-woo \u2502 Oracle Korea WPTG Team) (OTN\u2019s original original link has been removed)<\/p>\n\n\n\n<figure class=\"wp-block-table\" style=\"font-size:15px\"><table><tbody><tr><td>&nbsp;<\/td><td><strong>KO16KSC5601<\/strong><\/td><td><strong>KO16MSWIN949<\/strong><\/td><td><strong>UTF8<\/strong><\/td><td><strong>AL32UTF8<\/strong><\/td><\/tr><tr><td><strong>Korean support status<\/strong><\/td><td>Korean 2350 characters<\/td><td>KO16KSC5601 + extension 8822 characters (total 11172 characters)<\/td><td>Hangul 11172 characters<\/td><td>Hangul 11172 characters<\/td><\/tr><tr><td><strong>Character set\/encoding version<\/strong><\/td><td>Korean complete form<\/td><td>complete code included<br>Extended 8822 characters aligned according to MS Windows Codepage 949<\/td><td>Prior to 8.1.6: Unicode 2.1<br>Since 8.1.7: Unicode 3.0<\/td><td>9i Rel1: Unicode 3.0<br>9i Rel2: Unicode 3.1<br>10g Rel1: Unicode 3.2<br>10g Rel2: Unicode 4.0<\/td><\/tr><tr><td><strong>Hangul Byte<\/strong><\/td><td>2 bytes<\/td><td>2 bytes<\/td><td>3 bytes<\/td><td>3 bytes<\/td><\/tr><tr><td><strong>Supported version<\/strong><\/td><td>7.x<\/td><td>8.0.6 or later<\/td><td>8.0 onwards<\/td><td>9i Release 1 and higher<\/td><\/tr><tr><td><strong>Database Character set<\/strong><strong>Can be set to<\/strong><\/td><td>possible<\/td><td>possible<\/td><td>possible<\/td><td>possible<\/td><\/tr><tr><td><strong>National Character set<\/strong><strong>Can be set to<\/strong><\/td><td>impossible<\/td><td>impossible<\/td><td>possible<\/td><td>impossible<\/td><\/tr><tr><td><strong>Hangul Sort<\/strong><br><strong>(NLS_SORT&nbsp;<\/strong><strong>Set)<\/strong><\/td><td>Can be implemented with simple binary sort<\/td><td>Requires special options such as KOREAN_M or UNICODE_BINARY<br>(Refer to the description of Korean sorting)<\/td><td>Hangul sorting is possible with simple binary sorting. Sorting Chinese characters requires the KOREAN_M option<\/td><td>\u2013 Hangul support is the same as UTF8<\/td><\/tr><tr><td><strong>Advantages<\/strong><\/td><td>\u2013 No special advantages. High performance when it is certain to input and output only complete code<\/td><td>\u2013 All Korean characters can be stored\/input\/output with 2 bytes. All Korean characters can be input and output while space consumption is small.<br><\/td><td>\u2013 11,172 modern Korean characters are arranged in the correct order, so alignment is effective<br>\u2013 If other languages (Chinese, Thai, etc.) also need to be stored in the same database instance, there is no alternative other than Unicode character sets such as UTF8.<\/td><\/tr><tr><td><strong>disadvantage<\/strong><\/td><td>\u2013 There is a fatal disadvantage that only 2350 Korean characters are supported, so the use of character sets should be avoided in the future.<\/td><td>\u2013 In an attempt to be compatible with the finished type, the letter arrangement and sorting order are different. A simple \u201cORDER BY\u201d clause cannot properly sort Hangul.<\/td><td>One Korean character consumes 3 bytes, so space consumption is relatively large (1.5 times compared to 2 bytes), and performance must be consumed for Unicode encoding\/decoding.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>* \u201cUTF8\u201d supports only up to Unicode 3.0, and \u201cAL32UTF8\u201d supports the latest version of Unicode and the version to be released in the future.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Oracle documentation also recommends \u201cAL32UTF8\u201d.<\/p>\n\n\n\n<p>source:&nbsp;<a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch2charset.htm#NLSPG002\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch2charset.htm#NLSPG002<\/a><\/p>\n\n\n\n<p>Some excerpts are pasted below.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Database Character Set Statement of Direction<\/strong><br>A list of character sets has been compiled in Table A-4, \u201cRecommended ASCII Database Character Sets\u201d and Table A-5, \u201cRecommended EBCDIC Database Character Sets\u201d that Oracle strongly recommends for usage as the database character set. Other Oracle-supported character sets that do not appear on this list can continue to be used in Oracle Database 11g Release 2, but may be desupported in a future release. Starting with Oracle Database 11g Release 1, the choice for the database character set is limited to this list of recommended character sets in common installation paths of Oracle Universal Installer and Oracle Database Configuration Assistant. Customers are still able to create new databases using custom installation paths and migrate their existing databases even if the character set is not on the recommended list. However, Oracle suggests that customers migrate to a recommended character set as soon as possible.&nbsp;<span style=\"text-decoration: underline; background-color: #f6e199;\"><strong>At the top of the list of character sets that Oracle recommends for all new system deployment, is the Unicode character set AL32UTF8.<\/strong><\/span><\/p><p><strong>Choosing Unicode as a Database Character Set<\/strong><br><strong><span style=\"text-decoration: underline; background-color: #f6e199;\">Oracle recommends using Unicode for all new system deployments.<\/span><\/strong> Migrating legacy systems to Unicode is also recommended. Deploying your systems today in Unicode offers many advantages in usability, compatibility, and extensibility. Oracle Database enables you to deploy high-performing systems faster and more easily while utilizing the advantages of Unicode. Even if you do not need to support multilingual data today, nor have any requirement for Unicode, it is still likely to be the best choice for a new system in the long run and will ultimately save you time and money as well as give you competitive advantages in the long term. See Chapter 6, \u201cSupporting Multilingual Databases with Unicode\u201d for more information about Unicode.<\/p><\/blockquote>\n\n\n\n<p>Please refer to the underlined section above.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Up to this point, we have looked at the need for Oracle Character Set conversion and a guide for setting the correct Oracle Character Set. Next, we will look at the configuration of the client environment related to Oracle Character Set.<\/p>","protected":false},"excerpt":{"rendered":"<p>Let&#039;s look at the need for Oracle Character Set conversion and the correct Character Set setting guide. One of the troublesome problems related to data migration (data conversion, data migration, data migration) in many next-generation projects is Oracle&#039;s Character Set conversion. In most cases, incorrect Character Sets (e.g. US7ASCII) are converted to correct...<\/p>","protected":false},"author":1,"featured_media":11902,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,248,249],"class_list":["post-11901","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-character-set-","tag-character-set-conversion"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 , \uc124\uc815 \uac00\uc774\ub4dc \uac1c\uc694<\/title>\n<meta name=\"description\" content=\"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 \uacfc \uc62c\ubc14\ub978 Character Set \uc124\uc815 \uac00\uc774\ub4dc\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ud2b9\ud788 Character Set\uc774 US7ASCII\ub85c \uc798\ubabb \uc9c0\uc815\ub41c \uacbd\uc6b0 \uacaa\ub294 \uc5b4\ub824\uc6c0\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 , \uc124\uc815 \uac00\uc774\ub4dc \uac1c\uc694\" \/>\n<meta property=\"og:description\" content=\"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 \uacfc \uc62c\ubc14\ub978 Character Set \uc124\uc815 \uac00\uc774\ub4dc\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ud2b9\ud788 Character Set\uc774 US7ASCII\ub85c \uc798\ubabb \uc9c0\uc815\ub41c \uacbd\uc6b0 \uacaa\ub294 \uc5b4\ub824\uc6c0\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T12:43:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:58:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png\" \/>\n\t<meta property=\"og:image:width\" content=\"851\" \/>\n\t<meta property=\"og:image:height\" content=\"529\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(1): 1. \ud544\uc694\uc131, \uc62c\ubc14\ub978 Oracle Character Set \uc124\uc815 \uac00\uc774\ub4dc\",\"datePublished\":\"2022-10-02T12:43:33+00:00\",\"dateModified\":\"2022-10-04T14:58:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/\"},\"wordCount\":685,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-69.png\",\"keywords\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 , \uc124\uc815 \uac00\uc774\ub4dc \uac1c\uc694\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-69.png\",\"datePublished\":\"2022-10-02T12:43:33+00:00\",\"dateModified\":\"2022-10-04T14:58:23+00:00\",\"description\":\"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 \uacfc \uc62c\ubc14\ub978 Character Set \uc124\uc815 \uac00\uc774\ub4dc\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ud2b9\ud788 Character Set\uc774 US7ASCII\ub85c \uc798\ubabb \uc9c0\uc815\ub41c \uacbd\uc6b0 \uacaa\ub294 \uc5b4\ub824\uc6c0\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-69.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-69.png\",\"width\":851,\"height\":529},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-1-overview\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(1): 1. \ud544\uc694\uc131, \uc62c\ubc14\ub978 Oracle Character Set \uc124\uc815 \uac00\uc774\ub4dc\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Character Set Conversion Need, Setup Guide Overview","description":"This article explores the need for Oracle character set conversion and provides guidance on setting the correct character set. This can be particularly helpful when encountering difficulties due to incorrectly setting the character set to US7ASCII.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 , \uc124\uc815 \uac00\uc774\ub4dc \uac1c\uc694","og_description":"Oracle Character Set \ubcc0\ud658 \ud544\uc694\uc131 \uacfc \uc62c\ubc14\ub978 Character Set \uc124\uc815 \uac00\uc774\ub4dc\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ud2b9\ud788 Character Set\uc774 US7ASCII\ub85c \uc798\ubabb \uc9c0\uc815\ub41c \uacbd\uc6b0 \uacaa\ub294 \uc5b4\ub824\uc6c0\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-1-overview\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T12:43:33+00:00","article_modified_time":"2022-10-04T14:58:23+00:00","og_image":[{"width":851,"height":529,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(1): 1. \ud544\uc694\uc131, \uc62c\ubc14\ub978 Oracle Character Set \uc124\uc815 \uac00\uc774\ub4dc","datePublished":"2022-10-02T12:43:33+00:00","dateModified":"2022-10-04T14:58:23+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/"},"wordCount":685,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png","keywords":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/","name":"Oracle Character Set Conversion Need, Setup Guide Overview","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png","datePublished":"2022-10-02T12:43:33+00:00","dateModified":"2022-10-04T14:58:23+00:00","description":"This article explores the need for Oracle character set conversion and provides guidance on setting the correct character set. This can be particularly helpful when encountering difficulties due to incorrectly setting the character set to US7ASCII.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-69.png","width":851,"height":529},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-1-overview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(1): 1. \ud544\uc694\uc131, \uc62c\ubc14\ub978 Oracle Character Set \uc124\uc815 \uac00\uc774\ub4dc"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11901"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11901\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11902"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}