Productivity Skills Blog

Oracle Character Set Conversion Description Full Table of Contents

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....

Oracle Character Set Conversion (10): 6.3. How to convert CLOB type to Korean

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)...

Oracle Character Set Conversion (9): 6. How to Convert User Implemented Character Sets (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...

Oracle Character Set Conversion (7): 5.4. KO16MSWIN949 Environment CSSCAN Execution Result

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...

Oracle Character Set Conversion (6): 5.3. US7ASCII environment CSSCAN execution result

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...

Oracle Character Set Conversion (5): 5. Oracle Recommended Practice

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...

Oracle Character Set Conversion (4): 4.Configuring the 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...

Oracle Character Set Conversion (3): 3. Client Environment Configuration (2)

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...

Oracle Character Set Conversion (2): 3. Configuring the Client Environment (1)

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...

en_USEnglish