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: HKEY_LOCAL_MACHINE → SOFTWARE → Wow6432Node → ORACLE → KEY_OraDb11g_home1 please set NLS_LANG parameter in Japanese_Japan.JA16SJIS