[Database][Oracle]-The query results data in the Japanese language which is encoded as "?" in the output within UiPath

News Knowledge Base
1

The Oracle SQL query results in some data in the Japanese language which is encoded as "?" in the output within UiPath.

Overriding the NLA_LANG parameter with the correct Unicode for the Japanese language resolved the issue.

Detailed steps below:

  1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
  2. In the System variables section, click New.
  3. In the Variable Name field, enter NLS_LANG.
  4. In the Variable Value field, enter the NLS_LANG value specific to the language Unicode.
  5. The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
  6. For example American_America.UTF8.

In our case the NLA_LANG value was AMERICAN_AMERICA.JA16SJIS