Meta Thinking, Meta Working
I posted 10 articles on how to review and references to Oracle Character Set conversion, and the entire table of contents of the Oracle Character Set conversion explanation is compiled and posted separately. Click on the title of the table of contents to jump to the content of the article. 1. Need to convert Oracle Character Set 1.1. Misspecified Character Set (US7ASCII) 1.2....
Let'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)...
Continuing from the previous article (Oracle Character Set Conversion (8): 6. How to Convert a User-implemented Character Set (1)), we look at how to convert a user-implemented Character Set. You can check how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 using DB Link, CTAS, and UTL_RAW packages. 6.2.3. Method 3) DB Link & CTAS & UTL_RAW...
Let's take a look at the user-implemented Character Set conversion method. You can check how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 by using Oracle Utitlity Data Pump Export, Import. Methods that require separate implementation require technical verification and various...
Examine KO16MSWIN949 environment CSSCAN execution result. You can check schema creation, directory creation, csscan execution result file scan.txt, scan.out, scan.err contents, and csscan purpose. 5.4. EN16MSWIN949 Environment CSSCAN Execution Result 5.4.1. Execute the script below on the schema created KO16MSWIN949 instance to csscan...
Examine the US7ASCII environment CSSCAN execution result. Schema creation, directory creation, csscan execution result file scan.txt, scan.out, scan.err content, execution result table backup contents can be checked. This is a continuation of the previous article. Oracle Character Set Conversion(5): 5. Oracle recommended method...
Let's take a look at Oracle's recommended character set conversion method. You can check how to use CSALTER and its limitations, how to use CSSCAN and its execution order, the execution result file, and the DDL that creates the CSSCAN execution result storage table. This is a continuation of the previous article. Oracle Character Set Conversion(4): 4.Test Environment...
Continuing from the previous article, we look at the configuration of the Oracle Character Set conversion test environment. You can check Oracle server environment configuration (three instances, DB Link creation), test table creation, and test data creation scripts. This test environment was later used in the character set conversion process...
Continuing from the previous article, we look at the configuration of the Oracle Character Set conversion client environment. Oracle Server Character Set and Client NLS_LANG recommended four configurations can be checked. 3.2. Summary of test case execution results Previous article Oracle Character Set conversion (2): 3. Client environment configuration (1) of...
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...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español