{"id":11911,"date":"2022-10-02T23:11:13","date_gmt":"2022-10-02T14:11:13","guid":{"rendered":"https:\/\/prodskill.com\/?p=11911"},"modified":"2022-10-05T00:00:09","modified_gmt":"2022-10-04T15:00:09","slug":"oracle-character-set-migration-2-client-env-config-1","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/","title":{"rendered":"Oracle Character Set Conversion (2): 3. Configuring the Client Environment (1)"},"content":{"rendered":"<p>Examine Oracle Character Set conversion client environment configuration. Server Character Set and Client NLS_LANG settings can be divided into 9 test cases and the results of each test can be checked.<\/p>\n\n\n\n<p>This is a continuation of the previous article.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/oracle-character-set-conversion-1-overview\/\">Oracle Character Set Conversion(1): 1. Necessity, Correct Oracle Character Set Setup Guide<\/a><\/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-2-client-env-config-1\/#3_Oracle_Character_Set_%EB%B3%80%ED%99%98_Client_%ED%99%98%EA%B2%BD_%EA%B5%AC%EC%84%B1\" >3. Oracle Character Set Conversion Client Environment Configuration<\/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-2-client-env-config-1\/#31_%ED%85%8C%EC%8A%A4%ED%8A%B8_%EC%BC%80%EC%9D%B4%EC%8A%A4%EB%B3%84_%EA%B2%B0%EA%B3%BC\" >3.1. Results by test case<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#311_Case_1_US7ASCII_%E2%80%93_KO16KSC5601\" >3.1.1. Case #1 (US7ASCII \u2013 KO16KSC5601)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#312_Case_2_US7ASCII_%E2%80%93_KO16MSWIN949\" >3.1.2. Case #2 (US7ASCII \u2013 KO16MSWIN949)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#313_Case_3_US7ASCII_%E2%80%93_US7ASCII\" >3.1.3. Case #3 (US7ASCII \u2013 US7ASCII)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#314_Case_4_KO16MSWIN949_%E2%80%93_KO16KSC5601\" >3.1.4. Case #4 (KO16MSWIN949 \u2013 KO16KSC5601)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#315_Case_5_KO16MSWIN949_%E2%80%93_KO16MSWIN949\" >3.1.5. Case #5 (KO16MSWIN949 \u2013 KO16MSWIN949)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#316_Case_6_KO16MSWIN949_%E2%80%93_US7ASCII\" >3.1.6. Case #6 (KO16MSWIN949 \u2013 US7ASCII)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#317_Case_7_AL32UTF8_%E2%80%93_KO16KSC5601\" >3.1.7. Case #7 (AL32UTF8 \u2013 KO16KSC5601)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#318_Case_8_AL32UTF8_%E2%80%93_KO16MSWIN949\" >3.1.8. Case #8 (AL32UTF8 \u2013 KO16MSWIN949)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#319_Case_9-1_AL32UTF8_%E2%80%93_AL32UTF8\" >3.1.9. Case #9-1 (AL32UTF8 \u2013 AL32UTF8)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/#3110_Case_9-2_AL32UTF8_%E2%80%93_AL32UTF8_%E2%80%93_UTF-8_%EC%A7%80%EC%9B%90_PowerShell%EB%A1%9C_%EC%8B%A4%ED%96%89\" >3.1.10. Case #9-2 (AL32UTF8 \u2013 AL32UTF8) \u2013 UTF-8 Support Running with PowerShell<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"3._Oracle_Character_Set_\uad00\ub828_Client_\ud658\uacbd_\uad6c\uc131\"><span class=\"ez-toc-section\" id=\"3_Oracle_Character_Set_%EB%B3%80%ED%99%98_Client_%ED%99%98%EA%B2%BD_%EA%B5%AC%EC%84%B1\"><\/span>3. Oracle Character Set Conversion Client Environment Configuration<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The environment variable for setting the character set in Oracle Client is NLS_LANG.<\/p>\n\n\n\n<p>* Reference Oracle documentation: <a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e10729\/ch3globenv.htm#NLSPG189\" target=\"_blank\" rel=\"noreferrer noopener\">Choosing a Locale with the NLS_LANG Environment Variable (oracle.com)<\/a><\/p>\n\n\n\n<p>Commonly, it is thought that the Client NLS_LANG must match the Character Set of the Server, but this is not mandatory. Server Character Set is a setting for \u201cstoring\u201d character string data, and Client NLS_LANG is a setting for \u201cshowing\u201d and \u201csending\u201d character string data.<\/p>\n\n\n\n<p>In other words, if Server Character Set is incorrectly set, string data is stored incorrectly, and if Client NLS_LANG is incorrectly set, string data is incorrectly displayed and transmitted incorrectly.<\/p>\n\n\n\n<p>Define the case of Server Character Set and Client NLS_LANG settings as follows and look at the test results.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Case #<\/strong><\/td><td><strong>Server Character Set<\/strong><\/td><td><strong>Client NLS_LANG<\/strong><\/td><\/tr><tr><td>1<\/td><td>US7ASCII<\/td><td>AMERICAN_AMERICA.KO16KSC5601<\/td><\/tr><tr><td>2<\/td><td>US7ASCII<\/td><td>AMERICAN_AMERICA.KO16MSWIN949<\/td><\/tr><tr><td>3<\/td><td>US7ASCII<\/td><td>AMERICAN_AMERICA.US7ASCII<\/td><\/tr><tr><td>4<\/td><td>KO16MSWIN949<\/td><td>AMERICAN_AMERICA.KO16KSC5601<\/td><\/tr><tr><td>5<\/td><td>KO16MSWIN949<\/td><td>AMERICAN_AMERICA.KO16MSWIN949<\/td><\/tr><tr><td>6<\/td><td>KO16MSWIN949<\/td><td>AMERICAN_AMERICA.US7ASCII<\/td><\/tr><tr><td>7<\/td><td>AL32UTF8<\/td><td>AMERICAN_AMERICA.KO16KSC5601<\/td><\/tr><tr><td>8<\/td><td>AL32UTF8<\/td><td>AMERICAN_AMERICA.KO16MSWIN949<\/td><\/tr><tr><td>9<\/td><td>AL32UTF8<\/td><td>AMERICAN_AMERICA.AL32UTF8<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>To test the server character set differently, three Oracle instances were configured on the local PC and the TNS names were designated as oraus7, oramswin949, orautf, respectively.<\/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-71.png\"><img loading=\"lazy\" decoding=\"async\" width=\"873\" height=\"268\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png\" alt=\"\ud14c\uc2a4\ud2b8 DB\uc11c\ubc84 (Local PC) \uad6c\uc131\" class=\"wp-image-11912\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png 873w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71-300x92.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71-768x236.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71-36x11.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71-48x15.png 48w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\" \/><\/a><figcaption>Configuration of test DB server (Local PC)<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>oraus7: US7ASCII<\/li><li>oramswin949: KO16MSWIN949<\/li><li>orautf: AL32UTF8<\/li><\/ul>\n\n\n\n<p>Two input values for each test case were selected: \u201cHangul\u201d and \u201cSharp\u201d.<\/p>\n\n\n\n<p>\u201cHangul\u201d is to check whether general Korean input\/output is possible, and \u201csharp\u201d is to check the input\/output of characters not supported by KSC5601.<\/p>\n\n\n\n<p>The test script (example) and explanation are as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- Windows command prompt \ud658\uacbd\ntitle Test Case (1) US7ASCII, AMERICAN_AMERICA.KO16KSC5601\nset NLS_LANG=AMERICAN_AMERICA.KO16KSC5601\nsqlplus -S leg\/leg@oraus7\n\n-- sqlplus \ud658\uacbd\nTRUNCATE TABLE Z_TEST;\nINSERT INTO Z_TEST(VAL) VALUES('\ud55c\uae00');\nINSERT INTO Z_TEST(VAL) VALUES('\uc0fe');\nCOMMIT;\nSELECT VAL, DUMP(VAL, 1016) DP FROM Z_TEST;\nEXIT;<\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Line 2: Set the title of the Command prompt window for easy identification (different for each test case, see below)<\/li><li>Line 3: Set NLS_LANG (different for each test case, see below)<\/li><li>Line 4: Execute and connect to sqlplus (Set up differently for each test case. See below)<\/li><li>Line 7: Truncate the test table (Z_TEST)<\/li><li>Line 8: Enter the value \u201cHangul\u201d<\/li><li>Line 9: Enter the \u201csharp\u201d value<\/li><li>Line 10: Run COMMIT<\/li><li>Line 11: Output the input values and the result of the DUMP function<ul><li>Note: If you set the second parameter of the DUMP function to 1016, you can check the length of the stored value (number of bytes), character set, and the hexadecimal value of each byte.<\/li><\/ul><\/li><li>Line 12: end<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.1._\ud14c\uc2a4\ud2b8_\ucf00\uc774\uc2a4\ubcc4_\uacb0\uacfc\"><span class=\"ez-toc-section\" id=\"31_%ED%85%8C%EC%8A%A4%ED%8A%B8_%EC%BC%80%EC%9D%B4%EC%8A%A4%EB%B3%84_%EA%B2%B0%EA%B3%BC\"><\/span>3.1. Results by test case<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.1._Case_#1\"><span class=\"ez-toc-section\" id=\"311_Case_1_US7ASCII_%E2%80%93_KO16KSC5601\"><\/span>3.1.1. Case #1 (US7ASCII \u2013 KO16KSC5601)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: US7ASCII (sqlplus -S leg\/leg@us7ascii)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.KO16KSC5601<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input succeeded, output failed (output as a question mark (??))<\/li><li>&#039;sharp&#039;: input failed<\/li><\/ul><\/li><\/ul>\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-72.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72.png\" alt=\"Oracle Character Set \ubcc0\ud658 Client \ud658\uacbd \uad6c\uc131 Case #1 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11913\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-72-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Oracle Character Set Conversion Client Environment Configuration Case #1 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.2._Case_#2\"><span class=\"ez-toc-section\" id=\"312_Case_2_US7ASCII_%E2%80%93_KO16MSWIN949\"><\/span>3.1.2. Case #2 (US7ASCII \u2013 KO16MSWIN949)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: US7ASCII (sqlplus -S leg\/leg@us7ascii)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.KO16MSWIN949<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input succeeded, output failed (output as a question mark (??))<\/li><li>&#039;Sharp&#039;: input succeeds, output fails (outputs as a question mark (?))<\/li><\/ul><\/li><\/ul>\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-73.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73.png\" alt=\"Case #2 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11914\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-73-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #2 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.3._Case_#3\"><span class=\"ez-toc-section\" id=\"313_Case_3_US7ASCII_%E2%80%93_US7ASCII\"><\/span>3.1.3. Case #3 (US7ASCII \u2013 US7ASCII)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: US7ASCII (sqlplus -S leg\/leg@us7ascii)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.US7ASCII<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: Successful input and output (it is stored incorrectly)<\/li><li>&#039;Sharp&#039;: Successful input and output (it is stored incorrectly)<\/li><\/ul><\/li><\/ul>\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-74.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74.png\" alt=\"Case #3 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11915\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-74-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #3 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.4._Case_#4\"><span class=\"ez-toc-section\" id=\"314_Case_4_KO16MSWIN949_%E2%80%93_KO16KSC5601\"><\/span>3.1.4. Case #4 (KO16MSWIN949 \u2013 KO16KSC5601)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: KO16MSWIN949 (sqlplus -S leg\/leg@oramswin949)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.KO16KSC5601<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input, output successful<\/li><li>&#039;sharp&#039;: input failed<\/li><\/ul><\/li><\/ul>\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-75.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75.png\" alt=\"Case #4 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11916\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-75-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #4 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.5._Case_#5\"><span class=\"ez-toc-section\" id=\"315_Case_5_KO16MSWIN949_%E2%80%93_KO16MSWIN949\"><\/span>3.1.5. Case #5 (KO16MSWIN949 \u2013 KO16MSWIN949)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: KO16MSWIN949 (sqlplus -S leg\/leg@oramswin949)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.KO16MSWIN949<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input, output successful<\/li><li>&#039;sharp&#039;: input, output successful<\/li><\/ul><\/li><\/ul>\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-76.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76.png\" alt=\"Case #5 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11917\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-76-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #5 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.6._Case_#6\"><span class=\"ez-toc-section\" id=\"316_Case_6_KO16MSWIN949_%E2%80%93_US7ASCII\"><\/span>3.1.6. Case #6 (KO16MSWIN949 \u2013 US7ASCII)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: KO16MSWIN949 (sqlplus -S leg\/leg@oramswin949)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.US7ASCII<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input succeeded, output failed (output as a question mark (????))<\/li><li>&#039;sharp&#039;: input succeeded, output failed (output as a question mark (??))<\/li><\/ul><\/li><\/ul>\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-77.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77.png\" alt=\"Case #6 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11918\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-77-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #6 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.7._Case_#7\"><span class=\"ez-toc-section\" id=\"317_Case_7_AL32UTF8_%E2%80%93_KO16KSC5601\"><\/span>3.1.7. Case #7 (AL32UTF8 \u2013 KO16KSC5601)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: AL32UTF8 (sqlplus -S leg\/leg@orautf)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.KO16KSC5601<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input, output successful<\/li><li>&#039;sharp&#039;: input failed<\/li><\/ul><\/li><\/ul>\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-78.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78.png\" alt=\"Case #7 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11919\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-78-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #7 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.8._Case_#8\"><span class=\"ez-toc-section\" id=\"318_Case_8_AL32UTF8_%E2%80%93_KO16MSWIN949\"><\/span>3.1.8. Case #8 (AL32UTF8 \u2013 KO16MSWIN949)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: AL32UTF8 (sqlplus -S leg\/leg@orautf)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.KO16MSWIN949<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input, output successful<\/li><li>&#039;sharp&#039;: input, output successful<\/li><\/ul><\/li><\/ul>\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-79.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79.png\" alt=\"Case #8 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11920\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-79-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #8 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.9._Case_#9-1\"><span class=\"ez-toc-section\" id=\"319_Case_9-1_AL32UTF8_%E2%80%93_AL32UTF8\"><\/span>3.1.9. Case #9-1 (AL32UTF8 \u2013 AL32UTF8)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: AL32UTF8 (sqlplus -S leg\/leg@orautf)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.AL32UTF8<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input, output successful<\/li><li>&#039;Shop&#039;: Input failure: The default code page of the Windows command prompt (cmd.exe) is 949 (ANSI), and it does not support UTF-8 input\/output, so it does not run normally. If you execute it with PowerShell supporting UTF-8 input\/output (Case #9-2), you can see that the input\/output works normally.<\/li><\/ul><\/li><\/ul>\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-80.png\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"504\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80.png\" alt=\"Case #9-1 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11921\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80.png 667w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-80-48x36.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption>Case #9-1 Execution Result<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.10._Case_#9-2_(UTF-8_\uc9c0\uc6d0_PowerShell\ub85c_\uc2e4\ud589)\"><span class=\"ez-toc-section\" id=\"3110_Case_9-2_AL32UTF8_%E2%80%93_AL32UTF8_%E2%80%93_UTF-8_%EC%A7%80%EC%9B%90_PowerShell%EB%A1%9C_%EC%8B%A4%ED%96%89\"><\/span>3.1.10. Case #9-2 (AL32UTF8 \u2013 AL32UTF8) \u2013 UTF-8 Support Running with PowerShell<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Server Character Set: AL32UTF8 (sqlplus -S leg\/leg@orautf)<\/li><li>Client NLS_LANG: AMERICAN_AMERICA.AL32UTF8<\/li><li>Execution result<ul><li>&#039;Hangul&#039;: input, output successful<\/li><li>&#039;sharp&#039;: input, output successful<\/li><\/ul><\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81.png\" alt=\"Case #9-2 \uc2e4\ud589\uacb0\uacfc\" class=\"wp-image-11922\" width=\"597\" height=\"476\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81.png 597w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81-300x239.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81-24x19.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-81-48x38.png 48w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><\/a><figcaption>Case #9-2 Execution Result<\/figcaption><\/figure>\n<\/div>\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 configuration of the Oracle Character Set conversion client environment and the results of each test case. In the next article, we will summarize these results and look at the recommended configuration.<\/p>","protected":false},"excerpt":{"rendered":"<p>Examine Oracle Character Set conversion client environment configuration. Server Character Set and Client NLS_LANG settings can be divided into 9 test cases and the results of each test can be checked. This is a continuation of the previous article. Oracle Character Set Conversion(1): 1. Need, correct Oracle Character Set...<\/p>","protected":false},"author":1,"featured_media":11912,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,248,249,250],"class_list":["post-11911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-nls_lang"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Oracle Character Set \ubcc0\ud658 Client \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Server Character Set\uacfc Client NLS_LANG \uc124\uc815\uc744 9\uac00\uc9c0 \ud14c\uc2a4\ud2b8 \ucf00\uc774\uc2a4\ub85c \ub098\ub204\uc5b4 \uac01\uac01\uc744 \ud14c\uc2a4\ud2b8\ud55c \uacb0\uacfc\ub97c \ud655\uc778\ud560 \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-2-client-env-config-1\/\" \/>\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(2): 3. Client \ud658\uacbd \uad6c\uc131(1) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Oracle Character Set \ubcc0\ud658 Client \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Server Character Set\uacfc Client NLS_LANG \uc124\uc815\uc744 9\uac00\uc9c0 \ud14c\uc2a4\ud2b8 \ucf00\uc774\uc2a4\ub85c \ub098\ub204\uc5b4 \uac01\uac01\uc744 \ud14c\uc2a4\ud2b8\ud55c \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T14:11:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:00:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png\" \/>\n\t<meta property=\"og:image:width\" content=\"873\" \/>\n\t<meta property=\"og:image:height\" content=\"268\" \/>\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-2-client-env-config-1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1)\",\"datePublished\":\"2022-10-02T14:11:13+00:00\",\"dateModified\":\"2022-10-04T15:00:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/\"},\"wordCount\":455,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-71.png\",\"keywords\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"NLS_LANG\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-71.png\",\"datePublished\":\"2022-10-02T14:11:13+00:00\",\"dateModified\":\"2022-10-04T15:00:09+00:00\",\"description\":\"Oracle Character Set \ubcc0\ud658 Client \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Server Character Set\uacfc Client NLS_LANG \uc124\uc815\uc744 9\uac00\uc9c0 \ud14c\uc2a4\ud2b8 \ucf00\uc774\uc2a4\ub85c \ub098\ub204\uc5b4 \uac01\uac01\uc744 \ud14c\uc2a4\ud2b8\ud55c \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-71.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-71.png\",\"width\":873,\"height\":268},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-2-client-env-config-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1)\"}]},{\"@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 (2): 3. Client Environment Configuration (1) - Productivity Skill","description":"Examine Oracle Character Set conversion client environment configuration. Server Character Set and Client NLS_LANG settings can be divided into 9 test cases and the results of each test can be checked.","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-2-client-env-config-1\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1) - \uc0dd\uc0b0\uc131 Skill","og_description":"Oracle Character Set \ubcc0\ud658 Client \ud658\uacbd \uad6c\uc131 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Server Character Set\uacfc Client NLS_LANG \uc124\uc815\uc744 9\uac00\uc9c0 \ud14c\uc2a4\ud2b8 \ucf00\uc774\uc2a4\ub85c \ub098\ub204\uc5b4 \uac01\uac01\uc744 \ud14c\uc2a4\ud2b8\ud55c \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-2-client-env-config-1\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T14:11:13+00:00","article_modified_time":"2022-10-04T15:00:09+00:00","og_image":[{"width":873,"height":268,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.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-2-client-env-config-1\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1)","datePublished":"2022-10-02T14:11:13+00:00","dateModified":"2022-10-04T15:00:09+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/"},"wordCount":455,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png","keywords":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","NLS_LANG"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/","name":"Oracle Character Set Conversion (2): 3. Client Environment Configuration (1) - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png","datePublished":"2022-10-02T14:11:13+00:00","dateModified":"2022-10-04T15:00:09+00:00","description":"Examine Oracle Character Set conversion client environment configuration. Server Character Set and Client NLS_LANG settings can be divided into 9 test cases and the results of each test can be checked.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-71.png","width":873,"height":268},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-2-client-env-config-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(2): 3. Client \ud658\uacbd \uad6c\uc131(1)"}]},{"@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\/11911","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=11911"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11911\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11912"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}