How to solve the messy code issue when retrieving data in Oracle

If you run into the messy code issue when retrieving data in Oracle, please try the solutions below:

Step 1: Set the NLS_LANG (equal to the database server) on the machine where the PowerServer is installed.

Step 2: Go to the Register on both Oracle Server and the Server on which PowerServer is installed to check whether the NLS_LANG is the same in the directory of:

HKEY_LOCAL_MACHINE>SOFTWARE_ORACLE.

Step 3: Try to use the following solution to check whether the Web application can solve the Hebrew data issue.

  1. Locate Web.config under C:\Intetpub\wwwroot\appeon\AEM on the machine with PowerServer installed.

  2. Open Web.config with notepad and modify in the "globalization" line as shown below.

    <globalization requestEncoding="utf-8" responseEncoding="utf-8" 
    uiCulture="auto" culture="auto"/>
  3. Save the changes to the file.

  4. Restart IIS.