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.
-
Locate Web.config under C:\Intetpub\wwwroot\appeon\AEM on the machine with PowerServer installed.
-
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"/>
-
Save the changes to the file.
-
Restart IIS.
