Oracle Character Set Conversion Description Full Table of Contents

Methods worth reviewing and reference points for Oracle Character Set conversion are divided into 10 articles, and the entire table of contents for Oracle Character Set conversion explanations is organized and posted separately.

Click on the table of contents title to jump to the content of the article.

• 1. Oracle Character Set Conversion Needs
  • 1.1. Incorrectly specified Character Set (US7ASCII)
  • 1.2. Globalization of the system that was initially limited to domestic
• 2. Guide to Setting Up the Correct Oracle Character Set
• 3. Oracle Character Set Conversion Client Environment Configuration
  • 3.1. Results by test case
    • 3.1.1. Case #1 (US7ASCII – KO16KSC5601)
    • 3.1.2. Case #2 (US7ASCII – KO16MSWIN949)
    • 3.1.3. Case #3 (US7ASCII – US7ASCII)
    • 3.1.4. Case #4 (KO16MSWIN949 – KO16KSC5601)
    • 3.1.5. Case #5 (KO16MSWIN949 – KO16MSWIN949)
    • 3.1.6. Case #6 (KO16MSWIN949 – US7ASCII)
    • 3.1.7. Case #7 (AL32UTF8 – KO16KSC5601)
    • 3.1.8. Case #8 (AL32UTF8 – KO16MSWIN949)
    • 3.1.9. Case #9-1 (AL32UTF8 – AL32UTF8)
    • 3.1.10. Case #9-2 (AL32UTF8 – AL32UTF8) – Running with UTF-8 Support PowerShell
  • 3.2. Summary of test case execution results
  • 3.3 Oracle Server Character Set and Client NLS_LANG Recommended Configuration
• 4. Configure Oracle Character Set Conversion Test Environment
  • 4.1. Oracle DB Server Environment Configuration
  • 4.2. test table configuration
• 5. Oracle Recommended Character Set Conversion Method (CSALTER, CSSCAN)
  • 5.1. How to use CSALTER
  • 5.2. How to use CSSCAN
    • 5.2.1. Table to save CSSCAN execution results
  • 5.3. US7ASCII environment CSSCAN execution result
    • 5.3.1. create schema
    • 5.3.2. create directory
    • 5.3.3. run csscan
    • 5.3.4. Check csscan execution result-scan.txt (result summary report)
    • 5.3.5. Check csscan execution result-scan.out (scan target table information)
    • 5.3.6. Check csscan execution result-scan.err (error details)
    • 5.3.7. CSSCAN execution result table backup
  • 5.4. KO16MSWIN949 Environment CSSCAN Execution Result
    • 5.4.1. create schema
    • 5.4.2. create directory
    • 5.4.3. run csscan
    • 5.4.4. Check csscan execution result-scan.txt (Result summary report)
    • 5.4.5. Check csscan execution result-scan.out (scan target table information)
    • 5.4.6. Check csscan execution result - scan.err (error details)
  • 5.5. Note CSSCAN use
• 6. How to Convert User Implemented Character Set
  • 6.1. How to apply third party tools – ETL, etc.
  • 6.2. How to use Oracle Utility
    • 6.2.1. Method 1) Data Pump Export/Import
    • 6.2.2. Method 2) SQL*Loader
    • 6.2.3. Method 3) DB Link & CTAS & UTL_RAW
      • Test #1) Get ORAUS7 data from ORAMSWIN949
      • Test #2) Get ORAMSWIN949 data from ORAUTF
      • Test #3) Get ORAUS7 data from ORAUTF
      • Reference
        • Explore RAW data types
        • Character set conversion function CONVERT
        • Precautions
  • 6.3. How to convert CLOB type to Korean
    • 6.3.1. Check CLOB data
    • 6.3.2. CLOB data conversion

Related articles:

Oracle Character Set Conversion (10): 6.3. How to convert CLOB type to Korean Oracle Character Set Conversion (9): 6. How to Convert User Implemented Character Sets (2) Oracle Character Set Conversion(8): 6. How to Convert User Implemented Character Set (1) Oracle Character Set Conversion (7): 5.4. KO16MSWIN949 Environment CSSCAN Execution Result Oracle Character Set Conversion (6): 5.3. US7ASCII environment CSSCAN execution result Oracle Character Set Conversion (3): 3. Client Environment Configuration (2) Oracle Character Set Conversion (2): 3. Configuring the Client Environment (1) Oracle Character Set Conversion(1): 1. Necessity, Correct Oracle Character Set Setup Guide