Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:troubleshooting-guide:oracle:export:preserving_non_ansi_symbols [May 28, 2019, 11:48:10 AM] (current)
alexandr.kirpichny created
Line 1: Line 1:
 +====== Preserving Non-Ansi Symbols In Business Logic And Data ======
  
 +**Symptoms**
 +
 +For example when running a conversion in SQLWays Wizard on Japanese locale, it doesn't extract Shift-JIS encoding properly, it corrupts all Japanese characters instead.
 + 
 +**Cause**
 +
 +The Oracle option to extract Japanese characters from the source database and to display correctly the Japanese locale has not been set.
 +
 +**Solution**
 +
 +In order to extract all Japanese characters correctly from Oracle database working with Japanese locale, Oracle environment needs to be configured as follows:
 +In the following path HKEY_LOCAL_MACHINE -> SOFTWARE -> Wow6432Node -> ORACLE -> KEY_OraDb11g_home1 please set NLS_LANG parameter in Japanese_Japan.JA16SJIS
 +\\
 +
 +{{:sqlways:troubleshooting-guide:oracle:export:regedit_japan.png?nolink|}}
 +
 +\\
 +\\
 +__**Ispirer Note:**__
 +
 +   For Japanese characters you can try to use the NLS_LANG parameter provided in the article. For Korean characters you can try to set NLS_LANG parameter to KOREAN_KOREA.KO16MSWIN949.
 +   For other types of characters we recommend to check the appropriate value of NLS_LANG parameters in the Oracle documentation.
sqlways/troubleshooting-guide/oracle/export/preserving_non_ansi_symbols.txt · Last modified: May 28, 2019, 11:48:10 AM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement