Preserving Japanese Symbols in Business Logic


When running a conversion in SQLWays Wizard on Japanese locale, it doesn't extract Shift-JIS encoding properly, it corrupts all Japanese characters instead.


The Oracle option to extract Japanese characters from the source database and to display correctly the Japanese locale has not been set.


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