Ispirer Ispirer
 

Preserving Japanese Symbols in Business Logic

Symptoms

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/preserving_japanese_symbols.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement