{"id":11974,"date":"2022-10-03T17:17:04","date_gmt":"2022-10-03T08:17:04","guid":{"rendered":"https:\/\/prodskill.com\/?p=11974"},"modified":"2022-10-05T00:13:54","modified_gmt":"2022-10-04T15:13:54","slug":"oracle-character-set-migration-10-convert-clob","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-10-convert-clob\/","title":{"rendered":"Oracle Character Set Conversion (10): 6.3. How to convert CLOB type to Korean"},"content":{"rendered":"<p>Let&#039;s look at how to convert CLOB type into Korean. You can check how to convert CLOB type containing Korean into AL32UTF8 in US7ASCII character set DB and the result of conversion.<\/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-migration-9-dblink-ctas-utl_raw\/\">Oracle Character Set Conversion (9): 6. How to Convert User Implemented Character Sets (2)<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-10-convert-clob\/#63_CLOB_type_%ED%95%9C%EA%B8%80_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\" >6.3. How to convert CLOB type to Korean<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-10-convert-clob\/#631_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%99%95%EC%9D%B8\" >6.3.1. Check CLOB data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-10-convert-clob\/#632_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B3%80%ED%99%98\" >6.3.2. CLOB data conversion<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"6.3._CLOB_\ubcc0\ud658_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"63_CLOB_type_%ED%95%9C%EA%B8%80_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\"><\/span>6.3. How to convert CLOB type to Korean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-8-datapump-export-import\/\">Oracle Character Set Conversion(8): 6. How to Convert User Implemented Character Set (1)<\/a><\/p>\n\n\n\n<p>In the above article, I mentioned the following:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>For reference, in the case of US7ASCII to AL32UTF8 conversion, CLOB type columns are not converted normally, so separate processing is required.<br>It will be explained in the next article.<\/p><\/blockquote>\n\n\n\n<p>This article describes how to convert a CLOB type containing Korean into AL32UTF8 using DB Link from US7ASCII to AL32UTF8. Oracle default package DBMS_LOB is used.<\/p>\n\n\n\n<p>First, let&#039;s check the CLOB data in the three instances ORAUS7, ORAMSWIN949, and ORAUTF.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.3.1._CLOB_\ub370\uc774\ud130_\ud655\uc778\"><span class=\"ez-toc-section\" id=\"631_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%99%95%EC%9D%B8\"><\/span>6.3.1. Check CLOB data<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Execute the following INSERT statement in the three instances ORAUS7, ORAMSWIN949, and ORAUTF to fill the CLOB column (REF_DES) with data.<\/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=\"\">INSERT INTO SUB_MON_STAT\n(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM,\n ALIGHT_PASGR_NUM, WORK_DT, COMMT,\n REF_DES, REF_IMG)\nVALUES\n('201301', '1\ud638\uc120', '0150', '\uc11c\uc6b8\uc5ed', 2199181,\n 1855268, '20130723', RPAD('\uc11c\uc6b8\uc5ed', 3000, '\uc11c\uc6b8\uc5ed'),\n RPAD('\uc11c\uc6b8\uc5ed', 3000, '\uc11c\uc6b8\uc5ed'), UTL_RAW.CAST_TO_RAW('12345'))\n;<\/pre>\n\n\n\n<p>The data type of each column is 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-84.png\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"253\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png\" alt=\"Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uad6c\uc131\" class=\"wp-image-11938\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png 894w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-300x85.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-768x217.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-48x14.png 48w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/a><figcaption>Oracle Character Set Conversion Test Table Configuration<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Now, let&#039;s check the ref_des column (CLOB type) data in each instance with the following SQL.<\/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=\"\">select dbms_lob.getlength(ref_des) chr_len\n      ,lengthb(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1)) byte_len\n      ,dump(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1), 1016) dp\n      ,ref_des\n  from sub_mon_stat\n where ref_des is not null\n   and rownum &lt;= 1\n;<\/pre>\n\n\n\n<p><strong>\u25bc ORAUS7<\/strong><\/p>\n\n\n\n<p>The character set of CLOB data is US7ASCII, and Korean is not displayed normally.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-1024x702.png\" alt=\"ORAUS7 CLOB \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11975\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>ORAUS7 CLOB data check<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The number of characters (chr_len) is 3,000, and the number of bytes (byte_len) is also 3,000. That is, it can be seen that one character is stored as one byte.<\/p>\n\n\n\n<p>I couldn&#039;t find a way to set NLS_LANG in SQL Developer, so I checked that Hangul was displayed by running it in sqlplus.<\/p>\n\n\n\n<p>If NLS_LANG is set to US7ASCII as shown below, Korean is displayed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98.png\"><img loading=\"lazy\" decoding=\"async\" width=\"873\" height=\"736\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98.png\" alt=\"ORAUS7 CLOB \ud55c\uae00 \ub370\uc774\ud130 \ud655\uc778 (sqlplus, NLS_LANG=US7ASCII)\" class=\"wp-image-11976\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98.png 873w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-300x253.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-768x647.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-36x30.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-48x40.png 48w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\" \/><\/a><figcaption>ORAUS7 CLOB Korean data check (sqlplus, NLS_LANG=US7ASCII)<\/figcaption><\/figure>\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=\"\">C:\\Users\\ymlee>set NLS_LANG=AMERICAN_AMERICA.US7ASCII\n\nC:\\Users\\ymlee>sqlplus leg\/leg@oraus7\n\nSQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 24 21:42:43 2022\n\nCopyright (c) 1982, 2010, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\n\nSQL> set pagesize 100\nSQL> set linesize 200\nSQL> select dbms_lob.getlength(ref_des) chr_len\n  2        ,lengthb(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1)) byte_len\n  3        ,substr(dump(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1), 1016), 1, 200) dp\n  4        ,ref_des\n  5    from sub_mon_stat\n  6   where ref_des is not null\n  7     and rownum &lt;= 1\n  8\nSQL> \/\n\n   CHR_LEN   BYTE_LEN\n---------- ----------\nDP\n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nREF_DES\n--------------------------------------------------------------------------------\n      3000       3000\nTyp=1 Len=3000 CharacterSet=US7ASCII: bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,\n\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\n\n\nSQL><\/pre>\n\n\n\n<p><strong>\u25bc ORAMSWIN949<\/strong><\/p>\n\n\n\n<p>Character set of CLOB data is KO16MSWIN949, and Korean is displayed normally.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-1024x702.png\" alt=\"KO16MSWIN949 CLOB \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11977\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>KO16MSWIN949 CLOB data check<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The number of characters (chr_len) is 1,500, and the number of bytes (byte_len) is 3,000. That is, it can be seen that one character is stored as 2 bytes.<\/p>\n\n\n\n<p><strong>\u25bc ORAUTF<\/strong><\/p>\n\n\n\n<p>Character set of CLOB data is AL32UTF8, and Korean is displayed normally.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-1024x702.png\" alt=\"\" class=\"wp-image-11978\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>ORAUTF CLOB data check<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The number of characters (chr_len) is 1,334, and the number of bytes (byte_len) is 4,000. That is, it can be seen that one character is stored as 3 bytes.<\/p>\n\n\n\n<p>(The exact number of bytes is 4,002, but there is a slight difference because the maximum number of bytes returned by dbms_lob.substr is 4,000)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.3.2._CLOB_\ub370\uc774\ud130_\ubcc0\ud658\"><span class=\"ez-toc-section\" id=\"632_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B3%80%ED%99%98\"><\/span>6.3.2. CLOB data conversion<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>CLOB data cannot execute select through DB Link. I am getting &quot;ORA-22992: cannot use selected LOB location from remote table&quot; error.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-1024x702.png\" alt=\"CLOB \ub370\uc774\ud130\ub97c DB Link\ub85c query\ud560 \ub54c ORA-22992 \uc624\ub958\" class=\"wp-image-11979\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>ORA-22992 error when querying CLOB data with DB Link<\/figcaption><\/figure>\n<\/div>\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=\"\">select use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt, commt\n      ,ref_des\n  from sub_mon_stat@dl_us7 a\n;\n\nORA-22992: \uc6d0\uaca9 \ud14c\uc774\ube14\ub85c \ubd80\ud130 \uc120\ud0dd\ub41c LOB \uc704\uce58\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4\n22992. 00000 -  \"cannot use LOB locators selected from remote tables\"\n*Cause:    A remote LOB column cannot be referenced.\n*Action:   Remove references to LOBs in remote tables.<\/pre>\n\n\n\n<p>You can copy data using the Create Table As Select (CTAS) syntax 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=\"\">create table sub_mon_stat_from_oraus7\nas\nselect use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt\n      ,ref_des\n  from sub_mon_stat@dl_us7 a\n;\n\nselect dbms_lob.getlength(ref_des) chr_len\n      ,lengthb(dbms_lob.substr(ref_des, 1333, 1)) byte_len\n      ,dump(dbms_lob.substr(ref_des, 1333, 1), 1016) dp\n      ,ref_des\n  from sub_mon_stat_from_oraus7\n where ref_des is not null\n   and rownum &lt;= 1\n;<\/pre>\n\n\n\n<p>As you can see from the above query execution result, the character set of the CLOB column was converted to AL32UTF8, but the Korean character string was not converted normally.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-1024x702.png\" alt=\"CTAS\ub85c \uc0dd\uc131\ud55c Table \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11980\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Check table data created with CTAS<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The process of converting Hangul of a CLOB column is 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-103.png\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"395\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png\" alt=\"CLOB \uceec\ub7fc\uc758 \ud55c\uae00\uc744 \ubcc0\ud658\ud558\ub294 \uacfc\uc815 \uc694\uc57d\" class=\"wp-image-11981\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png 612w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-300x194.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-48x31.png 48w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><figcaption>Summary of the process of converting Hangul of CLOB column<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\"><li>Create a view that converts the data type of the CLOB column to BLOB in the source DB (Instance #1, ORAUS7)<\/li><li>Create a table in the target DB (Instance #3, ORAUTF) with CTAS (Create Table As Select) statement<\/li><li>Create table by converting BLOB data type of table created above to CLOB type<\/li><\/ol>\n\n\n\n<p>Let&#039;s take a look one by one.<\/p>\n\n\n\n<p><strong>1. Create a view that converts the data type of CLOB column to BLOB in the source DB (Instance #1, ORAUS7)<\/strong><\/p>\n\n\n\n<p>If the data type of the CLOB column is converted to BLOB, the character set is not converted when querying with DB Link.<\/p>\n\n\n\n<p>Create a function that converts CLOB to BLOB using the DBMS_LOB.CONVERTTOBLOB procedure 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=\"\">CREATE OR REPLACE FUNCTION FN_CLOB_TO_BLOB (P_CLOB CLOB) RETURN BLOB\nAS\n L_BLOB          BLOB;\n L_DEST_OFFSET   INTEGER := 1;\n L_SOURCE_OFFSET INTEGER := 1;\n L_LANG_CONTEXT  INTEGER := DBMS_LOB.DEFAULT_LANG_CTX;\n L_WARNING       INTEGER := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;\nBEGIN\n  IF DBMS_LOB.GETLENGTH(P_CLOB) != 0 THEN\n      DBMS_LOB.CREATETEMPORARY(L_BLOB, TRUE);\n      DBMS_LOB.CONVERTTOBLOB\n      (\n       DEST_LOB    =>L_BLOB,\n       SRC_CLOB    =>P_CLOB,\n       AMOUNT      =>DBMS_LOB.LOBMAXSIZE,\n       DEST_OFFSET =>L_DEST_OFFSET,\n       SRC_OFFSET  =>L_SOURCE_OFFSET,\n       BLOB_CSID   =>DBMS_LOB.DEFAULT_CSID,\n       LANG_CONTEXT=>L_LANG_CONTEXT,\n       WARNING     =>L_WARNING\n      );\n  END IF;\n  RETURN L_BLOB;\nEND;<\/pre>\n\n\n\n<p>Then, create a View using the above function.<\/p>\n\n\n\n<p>For testing purposes, only rows with values in some columns and CLOB column REF_DES were selected.<\/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=\"\">CREATE OR REPLACE VIEW VW_SUB_MON_STAT_BLOB\nAS\nSELECT  USE_MON, SUB_STA_ID\n       ,FN_CLOB_TO_BLOB(REF_DES) REF_DES_BLOB\n  FROM  SUB_MON_STAT\n WHERE  REF_DES IS NOT NULL;<\/pre>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>2. Create a table in the target DB (Instance #3, ORAUTF) using CTAS (Create Table As Select) syntax<\/strong><\/p>\n\n\n\n<p>Create a table by importing data from DB Link with the following syntax.<\/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=\"\">CREATE  TABLE SUB_MON_STAT_BLOB\nAS\nSELECT  A.*\n  FROM  VW_SUB_MON_STAT_BLOB@DL_US7 A;<\/pre>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>3. Create table by converting BLOB data type of table created above to CLOB type<\/strong><\/p>\n\n\n\n<p>Create a function to convert BLOB to CLOB using DBMS_LOB.CONVERTTOCLOB procedure 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=\"\">CREATE OR REPLACE FUNCTION FN_BLOB_TO_CLOB (P_BLOB BLOB) RETURN CLOB\nAS\n L_CLOB          CLOB;\n L_DEST_OFFSET   INTEGER := 1;\n L_SOURCE_OFFSET INTEGER := 1;\n L_LANG_CONTEXT  INTEGER := DBMS_LOB.DEFAULT_LANG_CTX;\n L_WARNING       INTEGER := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;\nBEGIN\n  DBMS_LOB.CREATETEMPORARY(L_CLOB, TRUE);\n  DBMS_LOB.CONVERTTOCLOB\n  (\n   DEST_LOB    =>L_CLOB,\n   SRC_BLOB    =>P_BLOB,\n   AMOUNT      =>DBMS_LOB.LOBMAXSIZE,\n   DEST_OFFSET =>L_DEST_OFFSET,\n   SRC_OFFSET  =>L_SOURCE_OFFSET,\n   --BLOB_CSID   =>DBMS_LOB.DEFAULT_CSID,\n   BLOB_CSID   =>846, -- NLS_CHARSET_ID('KO16MSWIN949')\n   LANG_CONTEXT=>L_LANG_CONTEXT,\n   WARNING     =>L_WARNING\n  );\n  RETURN L_CLOB;\nEND;<\/pre>\n\n\n\n<p>Among the parameters of the DBMS_LOB.CONVERTTOCLOB procedure, BLOB_CSID means \u201cThe character set ID of the source data\u201d.<\/p>\n\n\n\n<p>Please refer to the document below for more details.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_lob.htm#ARPLS602\" target=\"_blank\" rel=\"noreferrer noopener\">DBMS_LOB \u2013 CONVERTTOCLOB Procedure (oracle.com)<\/a><\/p>\n\n\n\n<p>BLOB_CSID must be specified as an integer type, not a string, and the value can be known with the NLS_CHARSET_ID function.<\/p>\n\n\n\n<p>Since the character set of the original data is KO16MSWIN949, 846 was confirmed by executing the following.<\/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-104.png\"><img loading=\"lazy\" decoding=\"async\" width=\"461\" height=\"194\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104.png\" alt=\"NLS_CHARSET_ID \ud568\uc218\ub85c BLOB_CSID \ud655\uc778\" class=\"wp-image-11982\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104.png 461w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-300x126.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-48x20.png 48w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/a><figcaption>Check BLOB_CSID with NLS_CHARSET_ID function<\/figcaption><\/figure>\n<\/div>\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=\"\">SELECT NLS_CHARSET_ID('KO16MSWIN949')\n  FROM DUAL;<\/pre>\n\n\n\n<p>And, you can create or query a table using the above function.<\/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=\"\">CREATE  TABLE SUB_MON_STAT_BLOB_TO_CLOB\nAS\nSELECT  USE_MON, SUB_STA_ID\n       ,FN_BLOB_TO_CLOB(REF_DES_BLOB) REF_DES\n  FROM  SUB_MON_STAT_BLOB A;\n\nselect *\n  from sub_mon_stat_blob_to_clob\n;\n\n-- Table \uc0dd\uc131\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 query \uac00\ub2a5\nselect use_mon, sub_sta_id\n       ,fn_blob_to_clob(ref_des_blob) ref_des\n  from sub_mon_stat_blob\n;<\/pre>\n\n\n\n<p>You can check that Hangul is converted normally as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-1024x702.png\" alt=\"CLOB \ud55c\uae00 \ubcc0\ud658\uacb0\uacfc \ud655\uc778\" class=\"wp-image-11983\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Check the result of CLOB Korean conversion<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>So far, we have looked at how to convert CLOB type containing Korean into AL32UTF8 in US7ASCII character set DB.<\/p>\n\n\n\n<p>It looks a little complicated because it goes through several processes, but it is not difficult if you look at it step by step.<\/p>\n\n\n\n<p>This article concludes the series on Oracle character set conversion.<\/p>\n\n\n\n<p>I hope to be of some help to those in need.<\/p>","protected":false},"excerpt":{"rendered":"<p>Let&#039;s take a look at the CLOB type Korean conversion method. In the US7ASCII character set DB, you can check how to convert the CLOB type including Hangul to AL32UTF8 and the conversion result. This is a continuation of the previous article. Oracle Character Set Conversion(9): 6. User Implementation Character Set Conversion Method(2)...<\/p>","protected":false},"author":1,"featured_media":11981,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[260,263,242,248,249,254,255,259],"class_list":["post-11974","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-db-link","tag-dbms_lob","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-us7ascii","tag-ko16mswin949","tag-al32utf8"],"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(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \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-10-convert-clob\/\" \/>\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(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-10-convert-clob\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T08:17:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:13:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png\" \/>\n\t<meta property=\"og:image:width\" content=\"612\" \/>\n\t<meta property=\"og:image:height\" content=\"395\" \/>\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=\"8 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-10-convert-clob\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95\",\"datePublished\":\"2022-10-03T08:17:04+00:00\",\"dateModified\":\"2022-10-04T15:13:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\"},\"wordCount\":318,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"keywords\":[\"DB Link\",\"DBMS_LOB\",\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"AL32UTF8\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"datePublished\":\"2022-10-03T08:17:04+00:00\",\"dateModified\":\"2022-10-04T15:13:54+00:00\",\"description\":\"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"width\":612,\"height\":395},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95\"}]},{\"@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 (10): 6.3. How to Convert CLOB Type to Korean - Productivity Skill","description":"Let&#039;s look at how to convert CLOB type into Korean. You can check how to convert CLOB type containing Korean into AL32UTF8 in US7ASCII character set DB and the result of conversion.","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-10-convert-clob\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","og_description":"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-10-convert-clob\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T08:17:04+00:00","article_modified_time":"2022-10-04T15:13:54+00:00","og_image":[{"width":612,"height":395,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95","datePublished":"2022-10-03T08:17:04+00:00","dateModified":"2022-10-04T15:13:54+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/"},"wordCount":318,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","keywords":["DB Link","DBMS_LOB","ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","AL32UTF8"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/","name":"Oracle Character Set Conversion (10): 6.3. How to Convert CLOB Type to Korean - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","datePublished":"2022-10-03T08:17:04+00:00","dateModified":"2022-10-04T15:13:54+00:00","description":"Let&#039;s look at how to convert CLOB type into Korean. You can check how to convert CLOB type containing Korean into AL32UTF8 in US7ASCII character set DB and the result of conversion.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","width":612,"height":395},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95"}]},{"@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\/11974","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=11974"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11974\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11981"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}