Knowledgebase

Search:     Advanced search

Question Marks Displayed When Querying Helix ALM Oracle Databases

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

Problem

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

Cause

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.

Solution

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
Tags
question mark Oracle query NLS_LANG

Prev   Next
Helix ALM Electronic Signature Exceptions     Removing index.html from the Helix ALM Web URL