Search:     Advanced search

Question Marks Displayed When Querying Helix ALM Oracle Databases

Article ID: 302  |  Last updated: 26 Jun, 2017


Question marks are displayed when you query data that was just inserted in a Helix ALM Oracle database.


Client applications are often in a different environment than the database server. In this case, the NLS_LANG setting of the client application may differ from the database character set and character set conversion is necessary.

When a target character set does not contain all characters in the source data, replacement characters such as the question mark, are used during conversion. The invalid characters in the target character set are all replaced with the question marks. Usually no error is returned when the replacement characters are used.


Create an NLS_LANG environment variable on the Helix ALM Server with a value of AMERICAN_AMERICA.WE8MSWIN1252 then restart the server.

Article ID: 302  |   Last updated: 26 Jun, 2017
question mark Oracle query NLS_LANG

Prev   Next
Troubleshooting Helix ALM Server Problems on Unix     Removing index.html from the Helix ALM Web URL